如何在 MySQL 中存储 unicode?

2021-11-20 00:00:00 unicode mysql

如何在 MySQL 免费版中存储 Unicode?

How do I store Unicode in free edition of MySQL?

似乎没有 SQL Server 中的 nvarchar 类型.MySQL 不支持 Unicode 吗?我尝试使用 text 但这也不起作用.

There doesn't seem to be nvarchar type as in SQL Server. Is Unicode not supported in MySQL? I tried using text but that too is not working.

推荐答案

您需要为您的表格选择一个 utf8_* 字符集.文本和备注字段将自动以 UTF-8 格式存储.mySQL 6 将支持 UTF-16.

You need to choose a utf8_* character set for your table. Text and memo fields will then automatically be stored in UTF-8. Support for UTF-16 is coming in mySQL 6.

相关文章