Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Database Character Set Conversion

JaKes9Mar 27 2017 — edited Mar 27 2017

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_VERSION12.1.0.2.0
NLS_NCHAR_CONV_EXCPFALSE
NLS_LENGTH_SEMANTICSBYTE
NLS_COMPBINARY
NLS_DUAL_CURRENCY$
NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_TZ_FORMATHH.MI.SSXFF AM TZR
NLS_TIMESTAMP_FORMATDD-MON-RR HH.MI.SSXFF AM
NLS_TIME_FORMATHH.MI.SSXFF AM
NLS_SORTBINARY
NLS_DATE_LANGUAGEAMERICAN
NLS_DATE_FORMATDD-MON-RR
NLS_CALENDARGREGORIAN
NLS_NUMERIC_CHARACTERS.,
NLS_NCHAR_CHARACTERSETAL16UTF16
NLS_CHARACTERSETAL32UTF8
NLS_ISO_CURRENCYAMERICA
NLS_CURRENCY$
NLS_TERRITORYAMERICA
NLS_LANGUAGEAMERICAN

Any help would be appreciated.

Thanks&Regards

JaKes

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2017
Added on Mar 27 2017
16 comments
9,087 views