Home > Archive > MySQL ODBC Connector > September 2005 > How to change table character set









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author How to change table character set
MightyData

2005-09-25, 3:23 am

I have a database that was created with MySQL 4.0. The character set for
each table is latin1. I have upgraded the server to MySQL 4.1. I would like
to change the character set for each table to utf8. What is the correct
procedure? Can I just change the table character set with an alter statement
or do I need to export data, alter table, then import data?

-------------------------------------------------------------------------
Kirk Bowman Phone: 972-390-8600
MightyData, LLC http://www.mightydata.com
FileMaker 7 Certified Developer FileMaker Authorized Trainer
Check out our FileMaker 7 training classes!
-------------------------------------------------------------------------


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Gleb Paharenko

2005-09-27, 7:23 am

Hello.

Have a look here:
http://dev.mysql.com/doc/mysql/en/c...-upgrading.html
http://dev.mysql.com/doc/mysql/en/c...conversion.html

MightyData wrote:
> I have a database that was created with MySQL 4.0. The character set for
> each table is latin1. I have upgraded the server to MySQL 4.1. I would like
> to change the character set for each table to utf8. What is the correct
> procedure? Can I just change the table character set with an alter statement
> or do I need to export data, alter table, then import data?
>
> -------------------------------------------------------------------------
> Kirk Bowman Phone: 972-390-8600
> MightyData, LLC http://www.mightydata.com
> FileMaker 7 Certified Developer FileMaker Authorized Trainer
> Check out our FileMaker 7 training classes!
> -------------------------------------------------------------------------
>
>



--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com