Database Administration (MOSC)

MOSC Banner

VARCHAR2(xxx char) to VARCHAR2(xxx byte) conversion

edited Dec 14, 2010 3:06AM in Database Administration (MOSC) 1 commentAnswered
 Im upgrading from a windows 10.2.0.3 32bit to a new windows server 11g2 x64 and noted a few issues that I need to resolve.
We are also going changing from WE8ISO8859P1 to AL32UTF8.

In my attempts at upgrading i had a few issues with invalid characters that I've fixed in the source db but am still faced with a truncation issue on import into an empty tablespace.  I know this is a character issue but I'm a little mistified on a way forward.

A little background - the original db was created using WE8ISO8859P1 and nls_length_sematics=byte. During a vendor product patch, it required nls_length_sematics=char.  This was done and we have had several vendor patches applied since then. Looking at the current schema tables, all VARCHAR2 columns are set to VARCHAR2(xxx char).

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center