Linux--CHCP

MySQL in the console, insert data into a table in the database, insert the data in Chinese, the results always show error incorrect string ..., cannot be inserted successfully

Guessing is an inconsistent encoding format. Console encoding format can be modified with the CHCP command

CHCP [nnn]

NNN Specifies the code page number.

Type CHCP without parameters to display the active code page number.

NNN specifies an existing system character set that is defined in the Config.sys file by the country command.

The code page can be set by the mode command under DOS.

Selected code page: MODE con[:] CP select=yyy

code page Status: MODE con[:] CP [/status]

Press Windows+r, and then enter CMD or command to open the prompt.

For example, input: Mode con cp select=936, which means simplified Chinese is displayed. If you enter mode con cp select=437, it shows MS-dos American English, and the Chinese display will be?.

MS-DOS provides character sets for the following countries and languages:

Code page description

1258 Vietnamese

1257 the Baltic language

1256 Arabic

1255 Hebrew

1254 Turkish

1253 Greek

1252 Latin 1 characters (ANSI)

1251 Cyrillic language

1250 Central European languages

950 Traditional Chinese

949 Korean

936 Simplified Chinese

932 Japanese

874 Thai

850 Multi-lingual (MS-DOS Latin1)

437 MS-DOS American English

Linux--CHCP