MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: changing default collation
Posted by: Shuichi Tamagawa
Date: July 07, 2005 12:48PM

Hi,

> 2) ALTER TABLE `table_name`
> DEFAULT CHARACTER SET latin1 COLLATE
> latin1_german1_ci

This only change the default character set and collation of the table and doesn't affect existing data. To change the the character set and collation of the existing data, you need to execute the statement like below.

ALTER `table_name` CONVERTO TO CHARACTER SET latin1 COLLATE latin1_german1_ci

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
changing default collation
10023
marco milli
July 07, 2005 08:44AM
Re: changing default collation
4418
Shuichi Tamagawa
July 07, 2005 12:48PM
Re: changing default collation
4246
marco milli
July 08, 2005 01:55AM


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.