Dear Simon, I develop project on QT/C++ and compile both Linux and Windows platforms. In this case, should I recompile SQLite both of these platforms?! Should I make some modifications on QT too?!
By the way is there any good guidence to add ICU support to SQLite both Linux and Windows platfoems?... On Mon, Apr 9, 2018 at 12:24 AM, Simon Slavin <slav...@bigfraud.org> wrote: > 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 > firstname.lastname@example.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Kolay gelsin, Mucip:) _______________________________________________ sqlite-users mailing list email@example.com http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users