Skip to main content

Searching of the value "i" in the filter pane returns also "y" values for 'lv-LV'

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Searching of the value "i" in the filter pane returns also "y" values for 'lv-LV'

Last Update:

May 10, 2022 3:23:50 PM

Updated By:

Jamie_Gregory

Created date:

Oct 30, 2017 12:34:41 PM

Searching the value "i", in the filter pane also returns "y" values and vice versa, when SET CollationLocale='lv-LV'; (Latvian alphabet) .

 

searching.png

Cause:

Checking in ICU - Unicode collation there are suggestion that for Latvian lv-LV alphabet searching for character 'a' would also highlight 'å' in en-US locale.

In the the attached screenshot, under 'Collated', in the list, its collated I,Y,J - which indicated that Y and I can be handled as the same letter.
source: http://demo.icu-project.org/icu-bin/locexp?_=lv&d_=en&x=col


intCode.png


This is a known behavior. Since letter I and Y are the same in Latvian alphabet, this has been considered the correct way to manage the search.

Labels (1)
Version history
Last update:
‎2022-05-10 03:23 PM
Updated by: