如何在MySQL中存储unicode? [英] How to store unicode in MySQL?
本文介绍了如何在MySQL中存储unicode?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在免费版本的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.
这篇关于如何在MySQL中存储unicode?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文