HI All,
My Database Version :Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
I had to change the database character set from 'WE8ISO8859p1' to 'AL32UTF8' to incorporate Unicode characters. We contacted DBA team and they changed the characterset to 'AL32UTF8'. But now the all the column's Data Length Semantics have changed to 'CHAR' for all the tables. Previously it was 'BYTE'. What could have happened as changing the characterset would not change the data type semantics.
I run the query on the database,
select * from nls_database_parameters;
and got result like,
NLS_RDBMS_VERSION | 12.1.0.2.0 |
NLS_NCHAR_CONV_EXCP | FALSE |
NLS_LENGTH_SEMANTICS | BYTE |
NLS_COMP | BINARY |
NLS_DUAL_CURRENCY | $ |
NLS_TIMESTAMP_TZ_FORMAT | DD-MON-RR HH.MI.SSXFF AM TZR |
NLS_TIME_TZ_FORMAT | HH.MI.SSXFF AM TZR |
NLS_TIMESTAMP_FORMAT | DD-MON-RR HH.MI.SSXFF AM |
NLS_TIME_FORMAT | HH.MI.SSXFF AM |
NLS_SORT | BINARY |
NLS_DATE_LANGUAGE | AMERICAN |
NLS_DATE_FORMAT | DD-MON-RR |
NLS_CALENDAR | GREGORIAN |
NLS_NUMERIC_CHARACTERS | ., |
NLS_NCHAR_CHARACTERSET | AL16UTF16 |
NLS_CHARACTERSET | AL32UTF8 |
NLS_ISO_CURRENCY | AMERICA |
NLS_CURRENCY | $ |
NLS_TERRITORY | AMERICA |
NLS_LANGUAGE | AMERICAN |
Any help would be appreciated.
Thanks&Regards
JaKes