Re: Some utf8 characters show correctly on one server, but do not on the other - SOLVED!
Posted by: Jos Smeets
Date: August 10, 2006 10:12AM

Again I reply to my own post. I solved my own problem :-)

It appeared that I had already converted some columns to utf8, but in an incorrect way, namely without using the intermediate BINARY() data type. I had to set the utf8 back to latin1 first, then go to binary, and then to utf8. When I then also use "SET NAMES utf8;", the columns are all converted as it should be. Also all utf8 characters now show correctly in MyPHPAdmin, where previously none did.

I thought I'd mention the solution here, in case someone encounters the same problem.

Cheers,
Jos

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Some utf8 characters show correctly on one server, but do not on the other - SOLVED!
1735
August 10, 2006 10:12AM


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.