The Windows CMD window cannot display Chinese, not necessarily garbled in the database--most of the cases just display the problem and can be resolved in the following ways:
1. Exit DOS or reopen in cmd window, lose:chcp 65001 then enter OK
Note: 65001 is the encoding of Unicode (UTF-8) 65001.
2, right-click on the command line title bar, select "Properties"-"Font", the font will be modified to "Lucida Console" OK (this font looks good, not necessary). Select the current window is valid or applies to all Windows
After the completion of the command to enter the Sqlite3,select to contain Chinese records, garbled solved.
Postscript:
If you want to restore back to the English or original Chinese Simplified (GB2312|GBK) encoding, the same type of encoding commands, the font can be adjusted according to their preferences.
chcp 65001 #换成utf-8 code page
chcp 936 #换成默认的gbk
chcp 437 #美国英语
The solution of using the Sqlite3 command to use the Chinese characters in DOS command