MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: Some utf8 characters show correctly on one server, but do not on the other - SOLVED!
Posted by: Sean Fang
Date: September 30, 2006 08:34AM

Hi, Jos,

Many thanks for sharing your experience with us. My situation is kind of close:
I have mySQL 4.0 tables with utf8 characters, I dump it to a flat file and then loaded up in a mySQL 4.1 database. The characters are displaying correctly in phpMyAdmin.

But when I write a php script and "select * from table" and output the words, they are not displaying correctly in the browser when I run the php script.

I guess that's the disconnection between mySQL4.0 and 4.1.

How do you think the issue I have can be fixed?
how exactly to do SET NAMES utf8? what's the difference between this and utf8->binary->utf8 like you mentioned?

Many thanks,

Sean

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Some utf8 characters show correctly on one server, but do not on the other
2665
Jos Smeets
August 03, 2006 08:33AM
Re: Some utf8 characters show correctly on one server, but do not on the other
1766
Jos Smeets
August 10, 2006 04:16AM
Re: Some utf8 characters show correctly on one server, but do not on the other - SOLVED!
1736
Jos Smeets
August 10, 2006 10:12AM
Re: Some utf8 characters show correctly on one server, but do not on the other - SOLVED!
1766
Sean Fang
September 30, 2006 08:34AM
Re: Some utf8 characters show correctly on one server, but do not on the other - SOLVED!
1754
Jonathan Reinfelds
October 02, 2006 10:40PM


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.