RE: NLS question

From: Michael Schmitt <mschmitt_at_uchicago.edu>
Date: Thu, 10 Mar 2011 22:02:57 -0600
Message-ID: <E37E556CF8A6C44381D2DA9FC354D24102EBFF7E037D_at_EVS03.ad.uchicago.edu>

Thanks Jimmy,

I was under the impression that the NLS_NCHAR_CHARACTERSET being set to AL16UTF16 would allow us to store this data for columns of type NCHAR, NVARCHAR2, and NCLOB

What is the purpose of the NLS_NCHAR_CHARACTERSET if that is not the case?

Thanks

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jimmy Brock Sent: Thursday, March 10, 2011 9:40 PM
To: oracle-l_at_freelists.org
Subject: NLS question

NLS_CHARACTERSET=US7ASCII means 256 characters see http://www.asciitable.com/

If you need support beyond ASCII you may want to consider changing the character set to WE8ISO8859P1. But before you do run the CSSCAN utility - it checks to see if your current data can be migrated.

csscan fromchar=US7ASCII tochar=WE8ISO8859P1

It will report if character migration will be successful.

If you have a very large database running may take a while to complete.

--

Jimmy Brock

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 10 2011 - 22:02:57 CST

This message: [ Message body ]
Next message: Dunbar, Norman (Capgemini): "RE: Simple PL/SQL output question"
Previous message: Jimmy Brock: "NLS question"
In reply to: Jimmy Brock: "NLS question"
Next in thread: Martin Berger: "Re: NLS question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message