Re: What does all_tab_columns.data_length actually store?

From: Mark Leonard <mark.leonard_at_tertio.com>
Date: 12 Jun 2003 03:53:13 -0700
Message-ID: <467336d2.0306120253.5530f29f_at_posting.google.com>

[Quoted] Yes. Both users are on the same database. The value of nls_length_semantics is CHAR. I ran the query you gave and the values of CHAR_LENGTH and CHARACTER_SET_NAME are the same for each user's table.

I think 4 bytes of data per char is probably correct, as the database is set to use UTF8 encoding.

I now suspect that somebody else in my company has changed the initialisation parameters without informing me. The user with BYTE semantics was created a day earlier than the user that has CHAR semantics.

We have modified our table creation scripts to contain the following command:
alter session set nls_length_semantics=byte; which should help on the consistency front.

SQL> select * from v$nls_parameters where parameter like '%CHARACTERSET'; PARAMETER

---

VALUE

---

NLS_CHARACTERSET
AL32UTF8 NLS_NCHAR_CHARACTERSET
AL16UTF16 Thanks for your reply...I'd welcome any advice regarding internationalisation. Received on Thu Jun 12 2003 - 12:53:13 CEST