Re: [sqlite] Hello everyone,

2019-10-03 Thread
When I open the sqlite.exe by cmd.It can print text normally(but the format is 
wrong).
But after I run"chcp 65001"(change the cmd code to utf-8) text become random 
code.
So,maybe the tool used WindowsOS's default code which itself running  on.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Thank you, and I found the tool maybe used Windows's default code, not utf-8.

2019-10-03 Thread
When I open the sqlite.exe by cmd.It can print text normally(but the format is 
wrong).
But after I run"chcp 65001"(change the cmd code to utf-8) text become random 
code.
So,maybe the tool used WindowsOS's default code which itself running  on.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Hello everyone, I found some strange behavior when using the Command Line Shell For SQLite.

2019-10-03 Thread
In column mode, each record is shown on a separate line with the data aligned 
in columns. For example:

sqlite> .mode column
sqlite> select * from tbl1;
one   two   
--  --
hello 10
goodbye   20
sqlite>


But I found,only when columns text is ANSI,it can normal work.

sqlite> .mode column
sqlite> select * from 语言声明表;
语言指针        引用数量        语言名称        语言注释
--  --  --  --
1           0           1           0
2           0           2           0

If the columns text is utf-8,it can't work.
What should I do for it?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users