Home >Database >Mysql Tutorial >How Can I Store Unicode Data in MySQL\'s Free Edition?

How Can I Store Unicode Data in MySQL\'s Free Edition?

Linda Hamilton
Linda HamiltonOriginal
2024-11-24 04:14:18993browse

How Can I Store Unicode Data in MySQL's Free Edition?

Storing Unicode in MySQL

Question:

How can Unicode be stored in the free edition of MySQL, considering that the "nvarchar" type found in SQL Server does not appear to be available? Does MySQL offer no Unicode support? Despite attempts to use the "text" datatype, success has not been achieved.

Answer:

Utilizing a UTF-8 character set is essential when creating tables. Consequently, both text and memo fields benefit from automatic storage in UTF-8. Notably, MySQL 6 anticipates the inclusion of UTF-16 support.

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn