Converting existing database
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?
-Rolf
Subject
Views
Written By
Posted
Converting existing database
2508
May 20, 2006 10:20AM
1470
June 08, 2006 05:17AM
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.