Oracle Database Discussions

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!

Why do I need nvarchar

Aacc-OracleJul 13 2009 — edited Jul 14 2009

In my 11g database,I specified multibyte support at installation time. I checked the nls_database_parameters table and saw the
NLS_CHARACTERSET AL32UTF8
so, I guess my database already support UTF8
also, I have some tables have varchar2 columns, the multibyte forgein charecters(such as Chinese) stored and displayed correctly in both sql developer and java application.
in another word, with above setting, I can support UTF8 now.
Question is, what does nvarchar2 do? anybody give me an use case that have to use nvarchar2 but not varchar2.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2009

Added on Jul 13 2009

#general-database-discussions

6 comments

980 views