On 8 Apr 2018, at 9:55pm, Dr. Mucibirahman İLBUĞA <mucip.ilb...@gmail.com> wrote:
> As you see above table it returns incorrect. Only i>>I is working like in > English language?! When I use this code in PostgreSQL it works correct. But I > got unexpected result in SQLite unfortunatelly. Thank you for your examples, which help me understand what you're asking for. Unfortunately, bare SQLite understands only ASCII characters. It does not understand Unicode. To build in full understanding of Unicode would make SQLite almost twice as long. However, you can add Unicode support to SQLite using ICU: <https://www.sqlite.org/src/artifact?ci=trunk&filename=ext/icu/README.txt> If you're compiling your own SQLite, use section 2 of the above document or the option SQLITE_ENABLE_ICU <https://www.sqlite.org/compile.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users