Is it picking it up from your NLS preferences under Tools -> Preferences -> Database -> NLS
You can swap the length between CHAR and BYTE
Thanks. NLS preference under Tools -> Preferences -> Database -> NLS is set to BYTE.
So doesn't appear to be picking it from there.
Why would you want BYTES over CHAR?
With BYTES you risk not having columns 'wide' enough to store all of your data based on your characterset.
With CHAR you're guaranteed to always be able to fit that many characters in your column.
Agree with your point, however we need it to be BYTE for following reasons:
BYTE is the default in Oracle and our datamodel uses the default option.With CHAR columns all character columns could become up to 4 times wider.
We are not worried about data not fitting in BYTE column as our application is designed with BYTE columns.
It would be a major re-testing exercise for us to test our application, which is already in production use at several customer sites.
I think we can get a 'fix' out to you, stay tuned.