Results 1 to 5 of 5

Thread: German umlauts

  1. #1
    Member
    Join Date
    Oct 2019
    Posts
    62

    German umlauts

    Problem with German umlauts.
    The German umlauts are not converted to upper case by the upper function, which is a big problem when searching for names, places and streets. Do you have to make settings to fix the problem or what options do you have?

  2. #2
    Member
    Join Date
    Oct 2019
    Posts
    62
    Name:  GermanUmlaute-Lianja.PNG
Views: 20
Size:  7.1 KB

  3. #3
    Junior Member
    Join Date
    Jun 2019
    Posts
    1
    Same thing with slavic latin letters - both UPPER("đčćĐČĆ") and LOWER("đčćĐČĆ") give the same result: đčćĐČĆ.
    Also, these functions don't work with cyrillic letters: lower("АСДФГХЈКЛшђчћжШЂЧЋЖ") and upper("АСДФГХЈКЛшђчћжШЂЧЋЖ") result in АСДФГХЈКЛшђчћжШЂЧЋЖ.

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,695
    Lianja uses UTF-8 internally. Indexes are case insensitive as are string comparisons. You do not need to convert to upper or lower case to search.
    Last edited by barrymavin; 2020-01-12 at 03:42.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  5. #5
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,695
    Lianja uses utf-8.

    In 5.2 to can use strconv(text, 7) for lowercase and strconv(text, 8) for uppercase. Thats how its down in VFP.

    I've also added upperc() and lowerc() that convert utf-8.

    There are a variety of other functions that operate on international character sets.

    Name:  Screen Shot 2020-01-12 at 3.29.28 PM.jpg
Views: 17
Size:  14.8 KB
    Last edited by barrymavin; 2020-01-12 at 03:43.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us