I. Preface
In the Unbuntu with sqlite3-command-line sqlite3 operation is also good, to the windows query table content found Chinese all garbled! I immediately thought that sqlite3 uses UTF-8 to encode the characters. In windows, the default encoding is gbk, and the cmd command environment is actually gbk. Garbled characters are normal. The solution is to modify the encoding method of the cmd command environment.
2. Get started
1. Enter the cmd command environment
// Use UTF-8 encoding instead of chcp 65001
2. Modify the font
Right-click the title bar of the command line, select "property"-> "font", change the font to "Lucida Console" of True Type, and click "OK" to apply the property to the current window.
III. Other Coding Paradigms
// Gbkchcp 936 // iso8859-1chcp 437
IV. References
Http://pjq.me/wiki/doku.php? Id = tips: enable-utf8-cmd & rev = 1303449997 & do = diff
Http://www.cnblogs.com/QQParadise/articles/1685177.htm
Respect original, reprinted please indicate from: http://www.cnblogs.com/fsjohnhuang/p/4081599.html ^_^ fat Zi John
CMD magic Hall: UTF8-encoded Chinese characters can be displayed.