RE: Replacement of US7ASCII character set in 11g?

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <janine@xxxxxxxxxx>, "oracle-l L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 8 Jan 2010 09:03:50 -0500


        I'm a little surprised that your client didn't make the move to
WE8ISO8859P1 some years ago as US7ASCII kinda became unacceptable in a
global world.  I moved several databases back then to WE8 and there were
no problems at all.  Those have since moved onto the Unicode character
sets without difficulty either.  CSSCAN is a good utility, but in
general you will be just fine. 

Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Janine Sisk
Sent: Thursday, January 07, 2010 4:10 PM
To: oracle-l L
Subject: Replacement of US7ASCII character set in 11g?

I am migrating a website from Oracle 8i to 11g, and one of the snags  
I've run into is the character set.

set to US7ASCII.  This character set seems to have disappeared in  
11g.  I tried making a database using Oracle's defaults, which are  
WE8MSWIN1252 and AL16UTF16 respectively.  The data looks ok so far,  
but my client is worried about problems we just haven't seen yet.

My question:  are there other choices for the two settings which would  
give us a better chance of having unmangled data than the ones Oracle  
chose?  If it matters, he's worried about the diacritics specifically,  
though I don't think he has actually found any yet that look wrong.

Also, a couple of related questions:

In 8i, I set the NLS_DATE_FORMAT by adding a line to the init.ora  
file.  In my Googling I have seen suggestions to set this by writing  
out a pfile, editing that, then converting it back to an spfile,  
basically doing the same thing I used to do but with the added steps  
of translating from and to the binary format.  This seems clunky;   
isn't there a better way?

Lastly, the client noticed that NLS_TIME_TZ_FORMAT has changed, not to  
his liking.  Would I set this in the same way as NLS_DATE_FORMAT,  
whatever that turns out to be?

Thanks for being patient with some very newbie questions!




Other related posts: