On Mon, Aug 07, 2017 at 11:45:50AM -0400, Richard Hipp wrote:
> 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.
Ah, OK, thanks for the correction!
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
