On Fri, Jun 6, 2014 at 5:26 PM, Martin Abel <martin.a...@enpenet.de> wrote:
> > select Name from Targets where Name like '%üabc%'; -- real UTF-8 chars "ü" > or alternatively > select Name from Targets where Name like '%üabc%'; -- real UTF-8 chars, > ASCII encoded as "ü" > > it does not work - no one of the German ä, ö, ü, Ä, Ö, Ü, ß work case > insensitive with the LIKE operator. > > Please try to fix that. > Case insensitivity in SQLite only applies to ASCII characters. This is because (up until relatively recently) the definition of Unicode case insensitivity was a moving target - it changing from one release of the Unicode definition to the next, but SQLite needed to be 100% backwards compatible at all times. Unicode now claims to have a fixed and unchanging definition of case insensitivity, but that only came about with (IIRC) unicode 6.1. If you need unicode case insensitivity for LIKE in SQLite, compile with SQLITE_ENABLE_ICU and then like it with libicu. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users