Bug 342746 - [sqlite collate] Translation memory searches aren't case insensitive for letters ä and ö
Summary: [sqlite collate] Translation memory searches aren't case insensitive for lett...
Status: RESOLVED UPSTREAM
Alias: None
Product: lokalize
Classification: Applications
Component: translation memory (show other bugs)
Version: unspecified
Platform: Compiled Sources Linux
: NOR normal
Target Milestone: ---
Assignee: Nick Shaforostoff
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-11 20:42 UTC by Lasse Liehu
Modified: 2019-10-19 14:53 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments
Finnish translation of Lokalize for quicker testing (30.96 KB, text/x-gettext)
2015-01-11 20:45 UTC, Lasse Liehu
Details
Finnish translation of Lokalize for quicker testing (second try) (116.92 KB, text/x-gettext)
2015-01-11 20:50 UTC, Lasse Liehu
Details

Note You need to log in before you can comment on or make changes to this bug.
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.