Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 13 2006
Added on Sep 1 2006
#general-database-discussions
8 comments
31,095 views