On Fri, May 11, 2012 at 1:25 PM, Luuk <luu...@gmail.com> wrote:
> On 11-05-2012 19:11, Richard Hipp wrote:
> > On Fri, May 11, 2012 at 12:20 PM, Frank Chang <frank_chan...@hotmail.com
> >wrote:
> >
> >>
> >> Good Afternoon, Is it possible to inserted European accented
> >> strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE? If so, could you
> >> please show us a brief example. Best Regards Frank.
> >>
> >
> > INSERT INTO user(name) VALUES('Gödel');
> >
>
> sqlite> select name, hex(name) from user;
> Gödel|479464656C
> G├Âdel|47C3B664656C
> sqlite>
>
> The first line was entered as you suggested (with the Windows7 sqlite3.exe)
>
> The secondline was entered using the FireFox
> plugin.(http://code.google.com/p/sqlite-manager/)
>
> I like the result of this second attempt more......
>
> So, question of OP remains ;)
>
Hmm... I suppose sqlite3.exe is not doing the necessary MBCS to UTF8
conversions. We'll have to address that for 3.7.13.
Your work-around is to use some flavor of Unix or to set your windows box
to use the unicode 65001 codepage.
>
> --
> Luuk
> _______________________________________________
> 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
