View Single Post
Old 02-16-2005, 09:44 AM   #1
Edomondo
Orange Mole
 
Edomondo's Avatar
 
Join Date: Jan 2004
Location: In outer space
Posts: 37
Storing UTF-8 in MySQL

I'm facing a problem about storing UTF-8 encoded character in MySQL.
I've googled around and many persons are having the same problem.

One of my page is UTF-8 encoded. It contains text fields whose content are stored to MySQL.
When I enter Japanese character in the box, they are not stored the correct way (either characters like メーãƒâ€*ルレジェンド 交響詩 宿命 or question marks ????????????????).
The problem is that PhpDig does store unicode character in MySQL very well! I've looked at its code but found no clues.
I've tried with utf8_encode & utf8_decode, htmlentities... but nothing worked.

Please help :-(
Edomondo is offline   Reply With Quote