xtech Posted January 28, 2014 Posted January 28, 2014 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 Posted January 28, 2014 Posted January 28, 2014 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 Posted January 28, 2014 Author Posted January 28, 2014 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 Posted January 28, 2014 Posted January 28, 2014 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 Posted January 28, 2014 Author Posted January 28, 2014 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...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.