Look into using the ICU extension. If you're compiling sqlite yourself, just define SQLITE_ENABLE_ICU to 1 (And link with the ICU libraries), otherwise you'll have to grab the source and compile it as a loadable module.
https://www3.sqlite.org/cgi/src/dir?ci=03c4f00317233a34&name=ext/icu for details. (Is there a way to link to the latest version of a file in the repository and not a particular commit?) On Fri, Feb 15, 2019 at 6:06 AM Aydin Ozgur Yagmur <[email protected]> wrote: > Hello, > > I want to use custom collations for "like" and "not equals" queries. > *select * from tbl_internal where col_internal like 'ç%' collate > TURKISH_CI;* > > it is ok for "equals" operator. > *select * from tbl_internal where col_internal = 'çç' collate TURKISH_CI;* > > but not ok, for "like" and "not equals" operators > > How can i make a search like these? Could you give me any clues? > > Thanks for advance, > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
