How to display explicitly CHAR or Byte in varchar2(10 CHAR)?

[felixxu]

Dears,

When we view table in PL/SQL developer,
If the NLS_LENGTH_SEMANTICS of Oracle database is set to CHAR,
we can see the column data type, such as, VARCHAR2(255);
However, in TOAD, we can see that is, VARCHAR2(255 CHAR),
Therefore, my question is, what should I do if I want to see VARCHAR2(255 CHAR) in PL/SQL developer?

Thank you.

 

[Marco Kalter]

PL/SQL Developer will only show BYTE/CHAR when it deviates from the default NLS_LENGTH_SEMANTICS. There is currently no option to override this and always show CHAR/BYTE.

 

[felixxu]

Dear Marco,
thanks for your reply.
I know what you mean, PL/SQL Developer only shows the CHAR or BYTE when it is different with the default set, actually this may be liable to cause misunderstanding especially when we create table in Database A from the script in Database B.
I suggest it is better to add the option under: User Interfact-> NLS Options.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[felixxu]

Thank you, Marco.