On Mon, Aug 07, 2017 at 03:29:41PM +0000, x wrote: > Apologies, I should have said I was using c++ builder Berlin on > windows 10 and that UnicodeString was UTF16. > > I thought I had learned enough about this string lunacy to get by but > finding out that the UTF8 code for the UTF16 code \u0085 is in fact > \uc285 has tipped me over the edge. I assumed they both used the same > codes but UTF16 allowed some characters UTF8 didn’t have.
Internally SQLite3 uses UTF-8. The SQLite3 API lets you deal with UTF-16, but this just transcodes to/from UTF-8 internally. So when you SELECT hex(<some value of type TEXT>); the hex() function sees UTF-8, not UTF-16. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
