RE: Which Character Set for 9.2

  • From: Janardhana Babu Donga <jbdonga@xxxxxxxxxxx>
  • To: "'Nelson, Allan'" <anelson@xxxxxxxxxxx>, Janardhana Babu Donga <jbdonga@xxxxxxxxxxx>, Rich.Jesse@xxxxxxxxxxxxxxxxx, gsais@xxxxxxxxxxxxxxxxxxx
  • Date: Wed, 27 Oct 2004 10:05:34 -0700

Dear List,

If it is not required to convert from US7ASCII to WE8ISO8859P1, I don't
understand why so many people are changing their character set to
WE8ISO8859P1 from US7ASCII. Could some one explain please?

-- Babu

-----Original Message-----
From: Nelson, Allan [mailto:anelson@xxxxxxxxxxx] 
Sent: Tuesday, October 26, 2004 5:54 PM
To: jbdonga@xxxxxxxxxxx; Rich.Jesse@xxxxxxxxxxxxxxxxx;
gsais@xxxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Which Character Set for 9.2

No. US7ASCII is a strict subset of WE8ISO8859P1.  This means that not
only is every symbol defined in US7ASCII also in WE8ISO8859P1 but that
these symbols are in the same entries in the respective symbol tables.
That's as good as it gets.

Allan

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Janardhana Babu
Donga
Sent: Tuesday, October 26, 2004 4:27 PM
To: 'Rich.Jesse@xxxxxxxxxxxxxxxxx'; gsais@xxxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Which Character Set for 9.2


I too am planning to convert from US7ASCII to WE8ISO8859P1. I am moving
the databases from HP boxes to Sun Solaris Systems. I am using Exp/Imp
to migrate. Old DB has US7ASCII character set. New DB will be created in
WE8ISO8859P1. 

I would like to know if the above character set conversion is required? 
Any help is appreciated.

-- Babu

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jesse, Rich
Sent: Tuesday, October 26, 2004 11:55 AM
To: gsais@xxxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Which Character Set for 9.2

I completely forgot about the "csscan" utility -- it should give you an
= idea of how much work you're in for.

Of course, it's probably best to run this on a recent complete copy of =
your DB, if possible...

Rich

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
Sent: Tuesday, October 26, 2004 12:55 PM
Subject: RE: Which Character Set for 9.2


Yeah, amen, etc.  We took finaancials at 11.5.7 to utf-8 and we had a
lot of data, principally from Russia, that had already been put into
non-utf-8 compliant homebrew software.  Boy was it fun to migrate that
stuff!

Allan
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l


____________________________________________________________________________
__
This email is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information.
Copying, forwarding or distributing this message by persons or entities
other than the addressee is prohibited. If you have received this email in
error, please contact the sender immediately and delete the material from
any computer.  This email may have been monitored for policy compliance.
[021216]
--
//www.freelists.org/webpage/oracle-l

Other related posts: