Database Administration (MOSC)

MOSC Banner

WANT TO CONVERT NLS_NHAR_CHARACTERSET to AL16UTF16

edited Oct 22, 2009 4:40AM in Database Administration (MOSC) 1 commentAnswered
 WANT TO CONVERT NLS_NHAR_CHARACTERSET to AL16UTF16
None of the Nvarchar, nchar exceeds the 1000 that is the upper limit to AL16UTF16.


WHAT STEPS TO PERFORM to CONVERT  THIS DB to NLS_NCHAR_CHARACTERSET

I DO NOT WNAT TO do export/import

NCHAR_CHARACTERSET

select distinct OWNER, TABLE_NAME, COLUMN_NAME, CHAR_LENGTH from DBA_TAB_COLUMNS where DATA_TYPE='NCHAR' and CHAR_LENGTH > 1000;

NO ROWS RETURNED.

Database was created with NLS_NCHAR_CHARACTERSET to UTF8.

select * from nls_database_parameters where parameter like '%NCHAR%';
NLS_NCHAR_CHARACTERSET    UTF8

I WANT TO CONVERT NLS_NHAR_CHARACTERSET to AL16UTF16

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center