SQL & PL/SQL

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!

Varchar2 datatype size problem

832089Jun 16 2011 — edited Jun 16 2011

Hi,

I am facing a very strange issue in one of my client database. After describing the table, it is showing the column datatype as varchar2(320) but when we tried to enter the data in that column it allows me to insert only 1/4 i.e. 80 charcter. Here the value of NLS_LENGTH_SEMANTIC=CHAR at the database level. Even if we alter the column and modify it to varchar2(100) then after describing , it is showing as varchar2(400). Its very strange for me and I am not able to understand that why it is having the actual value of 1/4th of the mentioned value.

Any idea, which parameter is responsible for it ?

Regards,,
Dheeraj Vaish

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2011

Added on Jun 16 2011

2 comments

396 views