Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AL32UTF8 - VARCHAR2 ok for Unicode ? No need for NVARCHAR2 ?

452507Jan 23 2006 — edited Mar 23 2006

If a 10gR2 database character set is AL32UTF8, then do VARCHAR2 columns suffice for storing unicode data of any language ? I'm hearing conflicting advice - some people are telling me NVARCHAR2 is necessary, others are saying VARCHAR2 is fine with AL32UTF8.

I'll be using AL32UTF8 anyway due to needs of XML data, but will also have some character data in "normal" SQL columns, so need to choose between VARCHAR2 and NVARCHAR2.

Thanks,
Andy Mackie.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2006

Added on Jan 23 2006

#database-key-features, #globalization-support

3 comments

11,673 views