RE: Which Character Set for 9.2
- From: "Nelson, Allan" <anelson@xxxxxxxxxxx>
- To: oraclestuff@xxxxxxxxx, gsais@xxxxxxxxxxxxxxxxxxx
- Date: Tue, 26 Oct 2004 12:54:44 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tim Johnston
Sent: Tuesday, October 26, 2004 11:10 AM
To: gsais@xxxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxx> 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
> --
> //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:
