storing unicode characters in mysql database
| From: | Naintara | Date: | Mon, 30 Jan 2006 11:27:52 +0000 |
| Subject: | storing unicode characters in mysql database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41157@lists.php.net to get a copy of this message | ||
Hi,
I'd like to know what would be the best way to store Unicode text in a
database. I am using MySQL 4.1.
I am trying to create a multi-lingual CMS and the browser charset is set to
utf-8 and the database and tables are set to UTF8 and utf8_bin for charset
and collation.
While displaying in the browser, Thai text is displayed correctly but it is
stored as html code in the database.
Is this correct behaviour or is there a better way?
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 27-Jan-06