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. I’m now wondering if I should go to the trouble of changing my sqlite wrapper over to communicate with the sqlite utf8 functions rather than the utf16 ones. Trouble is many of c++ builder’s built in types such as TStringList etc are utf16. From: Igor Tandetnik<mailto:i...@tandetnik.org> Sent: 07 August 2017 15:49 To: sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] hex and char functions On 8/7/2017 9:38 AM, x wrote: > Related > > Select hex(char(65,133,66)); returns ‘41C28542’ whereas I expected ‘418542’. > > What is the ‘C2’ about? Two-byte sequence C2 85 is the UTF-8 encoding of the Unicode codepoint U+0085. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
