Simon Slavin-3 wrote
> <https://www.sqlite.org/src/artifact?ci=trunk&filename=ext/icu/README.txt>
However the example described here is a little bit simplistic:
lower('I', 'en_us') -> 'i'
lower('I', 'tr_tr') -> 'ı' (small dotless i)
You depend on the encoding of the text editor, which has to match encoding
of the SQLite database. A more realistic example would be:
lower((BLOB CAST AS TEXT), 'tr_tr')
where the BLOB hast to be the string in one of the supported encodings:
UTF8, UTF16, UTF16le, UTF16be.
--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
