Page 1 of 1

Changing Mysql Character Coding

Posted: Mon Feb 23, 2015 8:45 am
by barabanovas
Long ago phpmyadmin had default encoding - "latin-swedish". I installed my joomla with this encoding. Now I would like to change it to UTF-8. Any suggestions? Because somehow I have to apply changes to all mysql data which is very big now.

Re: Changing Mysql Character Coding

Posted: Tue Feb 24, 2015 2:30 am
by umarzuki
create a script to use ALTER DATABASE and ALTER TABLE

Re: Changing Mysql Character Coding

Posted: Sat Feb 28, 2015 5:56 pm
by xfsgpr

Code: Select all

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Source: http://stackoverflow.com/questions/6115 ... n-to-utf-8