CHAR & VARCHAR2 under Oracle 9

[habanito]

Hello everybody,after we changed our database server into Oracle 9, when creating (with PL/SQL Developer ver.5.1.6) a table containing character fields, I get a "x3 dimension field".
For example :

create table DUMMY
( ITEM1 CHAR(3),
ITEM2 CHAR(2), etc...

after the table creation I got

table DUMMY
( ITEM1 CHAR(9), -> 3X
ITEM2 CHAR(6), -> 3X

Very strange don't you ?
Bye

 

[aotte]

You moved to UNICODE, or were you on UNICODE, and are you using byte vs. character length settings?

 

[habanito]

One thing has changed :

Oracle 8i had NLS_CHARACTERSET = ISO8859P1

Oracle 9 now has NLS_CHARACTERSET = UTF8 (being Chinese compatible).

 

[gulhaugen]

This is a known bug, and it is on the fix list. PLSQLDev doesn't check for CHAR semantics in the dictionary objects.

Check this link:
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=000540#000000