Hi All,
I have no problem setting up mysql 5 for utf8 (i've read its utf8 by default for mysql 5 however i don't believe this as mysql 5 docs say its still latin1 Swedish as always). The problem i'm having is just how difficult is this, i've been briefly reading into a few sites that say several ways to do this, and then come talk about the requirement of re-indexing everything, well i'm thinking if i iconv everything if that is a correct method and then would it still be able to re-index....

Plus we have some really complicated serialized arrays in the mysql database will things like this be effected??

I don't know a huge amount about mysql but i'm slowly going forward with it, any help is appreciated and i look forwards to your comments.

Cheers Regards,
..

hi
if you are using apache you can add
AddDefaultCharset utf-8
to the virtual hosts file for the site it has happened to me as well
also you chave to change the charset in mysql with
alter table "tablename" charset=utf8;
it should work

Hi...thanks for the reply..
I'm also under the impression that i will need to transform the current latin1 Swedish data to be utf8 characters...this is i believe very important? And i'm wondering what the best method may be as there appears to be several however people don't seem to be shouting about any method in particular that works excellent every time.

Cheers

is there any sort of select * from table ;paste to table with convertion of latin1 to utf8 characters probably not but worth an ask.