Details
-
Suggestion
-
Resolution: Fixed
-
P3: Somewhat important
-
4.7.2
-
None
-
4b7b5edf2 (dev)
Description
As written in the FAQ of SQLITE: "The default configuration of SQLite only supports case-insensitive comparisons of ASCII characters. The reason for this is that doing full Unicode case-insensitive comparisons and case conversions requires tables and logic that would nearly double the size of the SQLite library. The SQLite developers reason that any application that needs full Unicode case support probably already has the necessary tables and functions and so SQLite should not take up space to duplicate this ability". (see http://www.sqlite.org/faq.html item 18).
So the "SELECT LOWER('LØNN JOBB');" returns "lØnn jobb" instead of "lønn jobb".
In QT, we already have the upper and lower function supporting unicode.
It could be very interesting to reimplement "lower", "upper" and "like" functions of SQLITE based on QT.
To do that, you have to call sqlite3_create_function in the SQLITE driver.
Regards.
PS: This request is close to QTBUG-18084.