Re: How to change charset of a database?
Posted by: Dmitry Tolpeko
Date: February 02, 2005 03:16PM

Hi Bill,

MySQL allows you to specify the character set even at column level, so different columns can have different character sets. For this reason, I don't think that there is a command that will re-encode all data in the database.

You can change the default character set for the database using the ALTER DATABASE command. So you can use UTF-8 for new tables and data.

You can export/import your database in order to change the charset for existing data in the database.

---
Best regards, Dmitry Tolpeko
SQLWays - Data, Schema, Procedures conversion for MySQL.
http://www.ispirer.com

Options: ReplyQuote


Subject
Views
Written By
Posted
9632
February 02, 2005 12:58AM
Re: How to change charset of a database?
7570
February 02, 2005 03:16PM
8035
February 02, 2005 11:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.