Hi, sorry to post this again but i just realized i had posted it on the wrong forum.
anyway, i have a large database that has many fields with collation set to latin1_Swedish_ci and i want to change all of them to utf8_unicode_ci at once but i cant find the proper query for that. Something like UPDATE collate SET utf8_unicode_ci WHERE collate=latin1_Swedish_ci;
Is it possible?
Thank you.