utf8 character/collation problem with mySQL upgrade
Posted by:
Sean Fang
Date: September 30, 2006 08:41AM
It seems to me mySQL4.1 doesn't work well with utf8 characters in mySQL4.0
I have a table in 4.0 with utf8 columns, i dump the table into an mysql dump file and then load into a mysql4.1 database. i can see the utf8 characters correctly in mysql4.1 through phpMyAdmin.
The problem is: i have a php script which select * from table and outputs he characters. The utf8 words don't display correctly in my browser when I run the php script, the php script does put the output in charset=utf-8.
Anyone would like to share some thoughts on fixing such an issue?
Many thank,
Subject
Views
Written By
Posted
utf8 character/collation problem with mySQL upgrade
2976
September 30, 2006 08:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.