Tag Info

New answers tagged

1

I had the same problem with an Ubuntu installation of MySQL 5.6.23. I had to edit /etc/mysql/my.conf and add these entries to these sections: [client] default-character-set=utf8mb4 [mysqld] character-set-server = utf8mb4 [mysql] default-character-set=utf8mb4 Then as root execute: service mysql restart Both my webserver connections and my local ...


1

MySQL has no way to split a cell into a bunch of values. (Yeah, it can split a piece of a cell off -- see LEFT(), etc. But not an arbitrary set.) You would be better off doing the task in PHP or some other language -- more powerful than SQL. (Yeah, it could be done in a Stored Procedure, the the code would be really messy.) Here is some pseudo code for ...


1

I assume you will do this for each table? ALTER TABLE tbl CONVERT TO CHARACTER SET utf8mb4; One potential issue involves the maximum of 767 bytes per column in an INDEX. If you currently have a VARHAR(255) latin1 field in an index, you will need to rethink it. Decrease it to VARCHAR(191) if you are sure that 191 will suffice (into the future) Use a ...



Top 50 recent answers are included