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 ;)
--
Luuk
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
