| |
1, phenomenon: we set the database character set encoding when utf-8, we insert a column to a table of other language characters by DOS interface to encounter similar
data too long for column 'name' at row 1
mistake.
2, the cause:
variable_name value
charachter_set_client utf8
3, the solution:
(1) set names utf8; (only valid for the current window)
(2) find the mysql installation directory, the file is my.ini in the "default-character-set = " changed to "default-character-set = utf8", and then restart the mysql service |
|
|
|