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

Options: ReplyQuote


Subject
Views
Written By
Posted
9919
July 07, 2005 08:44AM
Re: changing default collation
4370
July 07, 2005 12:48PM
4199
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.