nls_length_semantics

[gulhaugen]

Working with a DB with nls_length_semantics=CHAR
plsql developer doesn't handle the result from describe very well. From SQL*Plus everything is correct.

PLSQL DEVELOPER:
SQL> -- Create table
SQL> create table test3
2 (
3 test3 varchar2(100)
4 )
5 tablespace ORA_DATA
6 storage
7 (
8 initial 20K
9 next 20K
10 minextents 1
11 maxextents 249
12 pctincrease 50
13 );

Table created

SQL> describe test3;
Name Type Nullable Default Comments
----- ------------- -------- ------- --------
TEST3 VARCHAR2(300) Y

SQL>

SQL*PLUS:
SQL> describe test3;
Name Null? Type
----------------------------------------- -------- ----------------------------
TEST3 VARCHAR2(100 CHAR)

SQL>

PLSQL Dev version 5.1.3.704
DB: 9.2.0.3
DB OS: Windows 2003

Morten

 

[Marco Kalter]

We'll fix this.

------------------
Marco Kalter
Allround Automations

 

[Intexcorp]

I would like to know when it will be fixed.
Also, any workaround in the mean time.

 

[Marco Kalter]

It is fixed in the 6.0 baseline. Version 6.0 will be available next month.