Solved

Converse database from LATIN1 to UTF8

Posted on 2006-10-31
4
601 Views
Last Modified: 2008-02-01
HI
I have a database which be used iso charset: LATIN1. I want to converse it to charset utf8. How can I do that
Please tell me solution
Thank you
0
Comment
Question by:VIETSKY
4 Comments
 
LVL 19

Accepted Solution

by:
VoteyDisciple earned 500 total points
ID: 17847237
This website ( http://confluence.atlassian.com/display/DOC/Configuring+Database+Character+Encoding )
suggests the best thing to do is:

1.  Do a mysqldump of your database
2.  Drop the database, and create it again with the encoding you want
3.  Import the mysqldump data again.


This seems pretty roundabout, and like the kind of thing that would be a huge hassle for a big database.  


Next up, http://dev.mysql.com/tech-resources/articles/4.1/unicode.html suggests altering individual columns to use UTF-8.  That too seems pretty darn tedious.


Finally, though, I hit on http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

The ALTER TABLE statement supports the following syntax:

ALTER TABLE blah CONVERT TO CHARACTER SET utf8;
0
 
LVL 8

Expert Comment

by:a0k0a7
ID: 17856121
Run the mySQL instance configurator from the server and change the default language from latin1 to utf8.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Accessibility and Usability are two concepts that seem to be closely related.  But, too many people seem to have a distorted perception of them. During last five years, those two words have come to the day-to-day work of almost every web develope‚Ķ
Learn by example how to specify CSS selectors for Selenium WebDriver test automation software.
The viewer will learn how to count occurrences of each item in an array.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now