mysql 字符串值不正确,mysql在django中保存unicode字符串时出现“字符串值不正确”错误...

我在尝试将名字、姓氏保存到Django的auth用户模型时收到奇怪的错误消息。

失败的例子

user = User.object.create_user(username, email, password)

user.first_name = u'Rytis'

user.last_name = u'SlatkeviÄius'

user.save()

>>> Incorrect string value: '\xC4\x8Dius' for column 'last_name' at row 104

user.first_name = u'ÐалеÑий'

user.last_name = u'Ðогданов'

user.save()

>>> Incorrect string value: '\xD0\x92\xD0\xB0\xD0\xBB...' for column 'first_name' at row 104

user.first_name = u'Krzysztof'

user.last_name = u'SzukieÅojÄ'

user.save()

>>> Incorrect string value: '\xC5\x82oj\xC4\x87' for column 'last_name' at row 104

成功的例子

user.first_name = u'Marcin'

user.last_name = u'Król'

user.save()

>>> SUCCEED

MySQL设置

mysql> show variables like 'char%';

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.00 sec)

表字符集和排序规则

表auth_用户具有带utf8_常规_-ci排序规则的utf-8字符集。

更新命令的结果

在使用update命令将上述值更新到auth用户表时,它没有引发任何错误。

mysql> update auth_user set last_name='SlatkeviÄiusa' where id=1;

Query OK, 1 row affected, 1 warning (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> select last_name from auth_user where id=100;

+---------------+

| last_name |

+---------------+

| Slatkevi?iusa |

+---------------+

1 row in set (0.00 sec)

《PostgreSQL》

当我在Django切换数据库后端时,上面列出的失败值可以更新到PostgreSQL表中。真奇怪。

mysql> SHOW CHARACTER SET;

+----------+-----------------------------+---------------------+--------+

| Charset | Description | Default collation | Maxlen |

+----------+-----------------------------+---------------------+--------+

...

| utf8 | UTF-8 Unicode | utf8_general_ci | 3 |

...

Name Bytes/Char

UTF8 1-4

这是否意味着Unicode char在PostgreSQL中的maxlen为4字节,而在MySQL中的maxlen为3字节,这导致了上述错误?