Solved

Converse database from LATIN1 to UTF8

Posted on 2006-10-31
4
600 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Problem to be resolved in this article Currently, development of website and web application can be done without writing thousands of lines of programming code by hand. Description This can be done through by using a open source framework such …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

746 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

16 Experts available now in Live!

Get 1:1 Help Now