Re: Upgrading from 4.0 to 4.1
Posted by: Alexander Barkov
Date: April 14, 2005 05:21AM

If you have a 4.0 table:

CREATE TABLE x (column varchar(150)) with utf8 data and want to upgrate to 4.1,

do these two steps following:

ALTER TABLE t1 MODIFY column VARBINARY(150);
ALTER TABLE t1 MODIFY column VARCHAR(150) CHARACTER SET utf8;

The first step will remove wrong assumption that character set it latin1 (which is default),
the seccond step will assign correct character set. Data will not be touched.

If you do it in a signle query, it tries to convert from latin1 to utf8, which is
not something desired.

Options: ReplyQuote


Subject
Views
Written By
Posted
3334
April 11, 2005 01:29PM
Re: Upgrading from 4.0 to 4.1
2296
April 14, 2005 05:21AM


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.