Bug 342746

Summary: [sqlite collate] Translation memory searches aren't case insensitive for letters ä and ö
Product: [Applications] lokalize Reporter: Lasse Liehu <lasse.liehu>
Component: translation memoryAssignee: Nick Shaforostoff <shafff>
Status: RESOLVED UPSTREAM    
Severity: normal CC: adrian
Priority: NOR    
Version First Reported In: unspecified   
Target Milestone: ---   
Platform: Compiled Sources   
OS: Linux   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:
Attachments: Finnish translation of Lokalize for quicker testing
Finnish translation of Lokalize for quicker testing (second try)

Description Lasse Liehu 2015-01-11 20:42:38 UTC 
Using latest KF5-based Lokalize from master. This bug affects latest kdelibs 4 based Lokalize, too. All system locale settings are fi_FI.UTF-8.

Reproducible: Always

Steps to Reproduce:
1. Make a new local translation memory with source language en_US and target language fi or use an automatically created project database for that.
2. Load some translations containing ä and ö into the TM. For example Finnish translation of Lokalize.
3. Search for some occurrences of them. For example if using Lokalize's Finnish translation, search "Älä" and "älä" in target field.

Actual Results:  
Searching for "Älä" only finds messages containing a substring where ä characters have the same case. Same when searching for "älä". Thus the search is case sensitive for ä characters.

Expected Results:  
The search results should be the same with for example "Älä" and "älä" because the search is case insensitive for letters a-z.
Comment 1 Lasse Liehu 2015-01-11 20:45:28 UTC 
Created attachment 90359 [details]
Finnish translation of Lokalize for quicker testing
Comment 2 Lasse Liehu 2015-01-11 20:50:46 UTC 
Created attachment 90360 [details]
Finnish translation of Lokalize for quicker testing (second try)
Comment 3 Adrián Chaves (Gallaecio) 2019-10-19 14:53:53 UTC 
If I understand correctly from https://stackoverflow.com/a/6578661/939364 the solution cannot be applied in Lokalize, but must instead be applied in SQLite itself by compiling it with the ICU extension.