Problem whith Oracle 9.2

[agambini]

Hy there,
I'm working whith Oracle DB 9.2.0.0 and I'm using a characterset UTF8 and NLS_LENGHT_SEMANTICS=CHAR because I'm developing Sw multi-Lang.
Whith this configuration, the lenght of the tables is three times as much as real. Unfortunately whith OEM (Oracle Enterprise Manager)I see the correct lenght.

For exemple whith:

CREATE TABLE PROOF (
INV_DEC_PLACES CHAR (3) NOT NULL,
EURO_IN_OUT CHAR (3) NOT NULL
) ;

whith PLSQL Developer I see CHAR(9). What can I do?

Thanks in advance!

------------------

 

[Marco Kalter]

Seems like a bug to me. We'll look into this.

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