PDA

View Full Version : Convert DB from iso8859-7 to UTF8

TheLab
03-14-2009, 08:47 AM
Hi all and apologies if this is not the correct category to post it.

I am trying to convert my database to UTF8 from iso 8859-7 greek but i can't seem to be able to do it without errors.

Can you point me to the correct direction or give me some hints of how i should be doing this?

Thanks in advance.
Dismounted
03-14-2009, 11:54 AM
How are you trying to convert the database? What errors do you get? (Make sure you have a backup of your database, changing character sets is not a simple task.)
TheLab
03-14-2009, 12:07 PM
Thanks for the quick reply. My problems start from the dump. If i use mysqldump from the console i can get the database but i can not read the greek letters with any editor (currently using ultraedit). If i dump the database through vb i can read the greek letters but the dump stops at 350mbs - db is currently 680mbs.

I have used different switches to mysqldump such as --default-character-set=ISO 8859-7
or --default-character-set=Greek but i still can't get a readable dump.
Marco van Herwaarden
03-14-2009, 12:55 PM
Why is it important to have a readible backup?
TheLab
03-14-2009, 01:19 PM
I don't know, but how can i convert it if i can't see the characters correctly?
Marco van Herwaarden
03-15-2009, 11:49 AM
You can change the characterset from within MySQL, no need for external editors or such.
TheLab
03-15-2009, 12:06 PM
You can change the characterset from within MySQL, no need for external editors or such.

Can you advice how please?

Thank you
Marco van Herwaarden
03-15-2009, 01:12 PM
That depends on what you want and what the current situation is.

If you open a support ticket with "FAO: Marco" as title, then i can sent you a script that will help you with this.
LoveStream
06-26-2009, 06:47 PM
You can change the characterset from within MySQL, no need for external editors or such.

Hi. Marco.

We have old about 1GB MySQL db with character set is KOREAN, but I would like to covert it to UTF-8 data.

I want to learn how its method to convert step by step or most easy and simple method.


Does it possible to convert just to adjust MySQL configure setting? If I were reset MySQL table parameter to unicode_UTF how the stored Korean TEXT would be converted?
Does it possible to convert without any backup except for the safe restore?
If I use phpMyAdmin tool to convert it, does it possible? Before I try to work I wish to hear your teaching.


Could you guide it to me?

Thanks in advanced.

from LS.
Dismounted
06-27-2009, 04:48 AM
Have a look at this article: https://vborg.vbsupport.ru/showthread.php?t=216863