Hi all,
In Oracle DDL, you can define a length for each VARCHAR2 column either in bytes or characters. I don't currently specify either (just a length), so Oracle is using the default, which is bytes. I want to switch to specifying everything in characters to minimise i18n issues, and I wondered...
a) Whether anyone has been through the process of changing an existing Oracle DB (that is accessed by a P4GL application) from bytes to characters
b) Whether anyone is using the OE10 Oracle Dataserver in an environment where the VARCHAR2 columns have lengths defined in characters rather than bytes
c) Whether anyone is aware of any nasties that are unique to that environment.
All wisdom gratefully received...
TIA
Tarby
In Oracle DDL, you can define a length for each VARCHAR2 column either in bytes or characters. I don't currently specify either (just a length), so Oracle is using the default, which is bytes. I want to switch to specifying everything in characters to minimise i18n issues, and I wondered...
a) Whether anyone has been through the process of changing an existing Oracle DB (that is accessed by a P4GL application) from bytes to characters
b) Whether anyone is using the OE10 Oracle Dataserver in an environment where the VARCHAR2 columns have lengths defined in characters rather than bytes
c) Whether anyone is aware of any nasties that are unique to that environment.
All wisdom gratefully received...
TIA
Tarby