On 8/7/17, Nico Williams <n...@cryptonector.com> wrote:
>
> Internally SQLite3 uses UTF-8. The SQLite3 API lets you deal with
> UTF-16, but this just transcodes to/from UTF-8 internally.
>
That is not quite correct.
SQL statements are always converted into UTF8 for parsing and code
generation. But data can be stored in the database file and processed
as UTF8, UTF16be, or UTF16le. All text content for a single database
must use the same encoding. When creating the database file, set the
encoding before adding any content by running one of:
PRAGMA encoding('utf-8');
PRAGMA encoding('utf-16be');
PRAGMA encoding('utf-16le');
See https://www.sqlite.org/pragma.html#pragma_encoding for additional
information.
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
