Change database from latin to utf8

http://stackoverflow.com/questions/279170/utf-8-all-the-way-through

Change database latin to utf8

ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

Change tables latin to utf8

ALTER TABLE product CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE product_wishlist CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE search_queries CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE token CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE user CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE user_credentials CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE wishlist CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Geef een reactie

Het e-mailadres wordt niet gepubliceerd. Vereiste velden zijn gemarkeerd met *

view: XS SM MD LG XL