Convert DB from iso8859-7 to UTF8

[TheLab]

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]

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]

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]

Why is it important to have a readible backup?

[TheLab]

I don't know, but how can i convert it if i can't see the characters correctly?

[Marco van Herwaarden]

You can change the characterset from within MySQL, no need for external editors or such.

[TheLab]

Originally Posted by Marco van Herwaarden

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]

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]

Originally Posted by Marco van Herwaarden

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]

Have a look at this article: https://vborg.vbsupport.ru/showthread.php?t=216863