Changing Mysql Character Coding

Joomla version 1.0 is end-of-life and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
barabanovas
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Mon Feb 23, 2015 8:04 am

Changing Mysql Character Coding

Post by barabanovas » Mon Feb 23, 2015 8:45 am

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.

umarzuki
Joomla! Intern
Joomla! Intern
Posts: 81
Joined: Fri May 02, 2008 8:35 am
Location: Malaysia
Contact:

Re: Changing Mysql Character Coding

Post by umarzuki » Tue Feb 24, 2015 2:30 am

create a script to use ALTER DATABASE and ALTER TABLE

User avatar
xfsgpr
Joomla! Ace
Joomla! Ace
Posts: 1020
Joined: Mon Feb 14, 2011 4:02 am
Location: London

Re: Changing Mysql Character Coding

Post by xfsgpr » Sat Feb 28, 2015 5:56 pm

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


Locked

Return to “Upgrading - 1.0.x”