Is there a fast way to change all the collation to utf8_unicode?

Posted by Mark on Stack Overflow See other posts from Stack Overflow or by Mark
Published on 2010-05-07T23:19:52Z Indexed on 2010/05/07 23:28 UTC
Read the original article Hit count: 200

Filed under:
|

I have realised after making about 20 tables that I need to user utf8_unicode as opposed to utf8_general. What is the fastest way to change it using PHPMyAdmin?

I had one idea: Export the database as SQL then using notepad run a find and replace on it and then reimport it... but it sounds like a bit of a headache.

Is there a better way?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about collation