On Wed, Feb 20, 2013 at 3:43 PM, Marco Bambini <ma...@sqlabs.net> wrote:
> Sometimes instead of a query like:
> "INSERT INTO foo (col1) VALUES ('Boxhagener Straße');"
>
> I receive the utf-8 encoded counterpart:
> "INSERT INTO foo (col1) VALUES ('Boxhagener Str\u00c3\u009fe');"
>
> Is there a way to automatically decode this latest query to UTF-8 just
> using sqlite API?
> Please note that since I have access to the sqlite amalgamation source
> code I could also expose an internal function.
>
SQLite assumes that all of its inputs are UTF (either UTF8 or UTF16). If
you give it an input of MBCS, it will store what you give it, byte for
byte, but for comparison and lookup purposes it always assumes it is UTF.
SQLite never tries to convert between MBCS and UTF (except as required deep
down inside the windows VFS, but that shouldn't be visible to the
application.)
>
> Thanks.
> --
> Marco Bambini
> http://www.sqlabs.com
> http://twitter.com/sqlabs
> http://instagram.com/sqlabs
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
