Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Character set changes
Hi all,
We have a new requirement to support Oracle LDAP server which requires the character set UTF8. Our current character set is US7ASCII. As described in the manual UTF8 is a superset of US7ASCII so I can do an ALTER DATABASE COMMAND to change the character set. (After backups and such). My question is since VARCHAR2s under UTF8 are sized by bytes what happens to existing tables columns. For example if I have a column DESCRIPTION VARCHAR2(2000); under US7ASCII how many characters will the the field hold under UTF8?
TIA
Dave
-- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.comReceived on Tue Aug 29 2000 - 11:54:06 CDT