[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.