Script for converting from UTF8 to UTF8MB4

[xtech]

Hi everybody,

i am searching for some procedure which i can run to convert the DB encoding from UTF8 to UTF8MB4. I am having some encoding issues which i need to solve, and i have figured out that MySQL only supports full Unicode through the UTF8MB4 encoding.

I have seen this:

http://mathiasbynens.be/notes/mysql-utf8mb4

Nevertheless, it would be a lot of time to individually change every table and running these instructions for each individual table.

How can automate this for every table?

Thank you in advance!

[jair101]

Check out this tool from IPS themselves: '?do=embed' frameborder='0' data-embedContent>>

First step when you run it is to ask you if you want to convert your dabatase to UTF8 or UTF8MB4. This tool gave some errors and didn't work for me, but I guess it can't hurt to try.

[xtech]

Thank you, i have used it to check if my prior conversion to UTF8 was ok (and it was). How can i use this to convert from UTF8 to UTF8MB4? I have not seen any option regarding utf8mb4..

[jair101]

Can't remember if it was in the command line interface, but definitely in the web version. Try that, there were two large buttons - convert with utf8 and convert with utf8mb4

[xtech]

Ahh thank you - i have run it through command line... now i tried the interface and i can see the utf8mb4 :smile:

Let's see if the script is good enough to deal with the indexes length...