How Can I Store Unicode Data in MySQL Free Edition?

Unicode Storage in MySQL Free Edition

The question has arisen as to how to store Unicode in the free edition of MySQL. One may initially think that Unicode is not supported in MySQL given the absence of an nvarchar type similar to that found in SQL Server. However, this is not the case.

To resolve the issue, you will need to select a utf8_* character set for your table. By doing so, text and memo fields will be automatically stored in UTF-8. It is important to note that support for UTF-16 is not yet available in MySQL; however, it is anticipated to be introduced in the upcoming MySQL 6 version.

The above is the detailed content of How Can I Store Unicode Data in MySQL Free Edition?. For more information, please follow other related articles on the PHP Chinese website!