Database Administration (MOSC)

MOSC Banner

NLS_CHARACTERSET - Changing columntype to NCHAR

edited Aug 27, 2014 5:03AM in Database Administration (MOSC) 1 commentAnswered

We have the problem of converting a database from WEISO8859P15 to ALL32UTF8.

On the import side CHAR (VARCHAR) fields turn out to be too small due to multibyte character conversion taking place.

I have some fundamental questions:

1. Is the NLS_CHARACTERSET global to a complete instance (SID) or is it possible to have schema or session wise character sets?

2. Can one change e.g. VARCHAR, VARCHAR2 or CHAR fields to NVARCHAR, NVARCHAR2 or NCHAR columntypes dynamically

    in a schema? And if so, could anyone provide a script for such?

Thanks,

Christoph

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