Re: Some utf8 characters show correctly on one server, but do not on the other - SOLVED!

[Jos Smeets]

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