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!

difference between varchar2(4000 byte) & varchar2(4000 char

432862Sep 1 2006 — edited Sep 15 2006

Hi,

My existing database NLS parameters as follows

CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16

created a test database to support globalization, I changed as follows

CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF8

some of the table column datatypes are varchar2(4000)

I would like to know what is difference between VARCHAR2(4000 BYTE) and VARCHAR2(4000 CHAR).

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2006

Added on Sep 1 2006

#general-database-discussions

8 comments

31,538 views