Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Which Character Set for 9.2

RE: Which Character Set for 9.2

From: Nelson, Allan <anelson_at_miswaco.com>
Date: Tue, 26 Oct 2004 12:54:44 -0500
Message-ID: <7E0DB3A126BA9146AC30744E2B7E4245974571@midhouhqxch01.net.smith.com>


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

-----Original Message-----
=46rom: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Johnston Sent: Tuesday, October 26, 2004 11:10 AM To: gsais_at_co.palm-beach.fl.us
Cc: oracle-l_at_freelists.org
Subject: Re: Which Character Set for 9.2

As Allan has said... Do you homework before the switch... Both UTF8 and WE8ISO8859P1 are strict supersets of US7ASCII... You can directly convert you database from US7ASCII to either of these charactersets... However, if you convert to WE8ISO8859P1 and then later decide you should have gone to UTF8 (or vice versa) then you have a migration on your hands...

On the other hand, moving to UTF8 does have potential issues...=20 Variable length characters... Application support etc...

Good luck

Tim

On Tue, 26 Oct 2004 10:32:35 -0400, Gene Sais <gsais_at_co.palm-beach.fl.us> wrote:
> I am upgrading my databases from 8i to 9.2.0.5. Currently, most of my

> databases are using the character set US7ASCII. What character set do

> most people in the USA use (WE8ISO8859P1)=3F
>=20
> Thanks,
> Gene
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://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]

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 26 2004 - 13:29:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US