The windoze console defaults to the OEM codepage. Change the console codepage before running sqlite3.exe or change the system default.
chcp 65001 see http://superuser.com/questions/269818/change-default-code-page-of-windows-console-to-utf-8 this applied the same on all versions of windoze. If you change the OEM default, you may never boot again, so be careful. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -----Original Message----- > From: [email protected] [mailto:sqlite-users- > [email protected]] On Behalf Of Luuk > Sent: Friday, 11 May, 2012 11:25 > To: [email protected] > Subject: Re: [sqlite] Is it possible to inserted European accented > strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE? > > On 11-05-2012 19:11, Richard Hipp wrote: > > On Fri, May 11, 2012 at 12:20 PM, Frank Chang > <[email protected]>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 ;) > > -- > Luuk > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
