Solved

Converse database from LATIN1 to UTF8

Posted on 2006-10-31
4
604 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
The viewer will learn how to dynamically set the form action using jQuery.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

728 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