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!

CHAR_COL_DECL_LENGTH in ALL_TAB_COLUMNS

jkkstar inc.Jul 5 2011 — edited Jul 6 2011
Hello,

Recently I've upgraded characterset of database to UTF8 and set NLS_LENGTH_SEMANTICS to CHAR.

I'm creating a sample table

create table sample4
(name1 char(1000),
name2 char(2000),
name3 varchar2(3000),
name4 varchar2(4000)
)
/

But the output in this query rounds the name3 column value to 4000 char even if it is less then 4000 chars. I'm trying to understand more in this multibyte conversion detail. Pleaes post any metalink note available in this regard.

thanks,

Kam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 3 2011
Added on Jul 5 2011
#general-database-discussions
2 comments
1,274 views