On 11-05-2012 19:47, Richard Hipp wrote:
> 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.
>
>
I was unable to enter the ö in my windows box.......
i tried, but after pressing Enter, i see command-prompt again ;)
C:\tmp>mode con cp select=65001
Status for device CON:
----------------------
Lines: 300
Columns: 160
Keyboard rate: 31
Keyboard delay: 1
Code page: 65001
C:\tmp>mode con cp /status
Status for device CON:
----------------------
Code page: 65001
C:\tmp>sqlite3 test.sqlite
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> insert into user(name) values ("G");
C:\tmp>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
