Re: How to change table character set

2005-09-27 Thread Gleb Paharenko
Hello.



Have a look here:

   http://dev.mysql.com/doc/mysql/en/charset-upgrading.html

   http://dev.mysql.com/doc/mysql/en/charset-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
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   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/[EMAIL PROTECTED]



How to change table character set

2005-09-24 Thread MightyData
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/[EMAIL PROTECTED]