Converting existing database
Posted by: Rolf Howarth
Date: May 20, 2006 10:20AM

If I have an existing database and use "alter database" on it to change the character set to utf8, that just changes the DEFAULT character set used when creating new tables, is that correct? Likewise, if I change the default character set on a table, that only affects the creation of new columns?

I'm not planning to change the schema, the thing I'm interested in is changing my EXISTING columns so they now support Unicode properly and not just latin1. Is there no easier way of doing that than altering all the columns individually?


Options: ReplyQuote

Written By
Converting existing database
May 20, 2006 10:20AM

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.