RE: Character sets

From: lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk>
Date: Fri, 15 Dec 2000 15:30:41 -0000
Message-Id: <10711.124715@fatcity.com>

can the reverse be done WE8ISO8859P1 to US7ASCII ??

Regards

> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk

>=20

-----Original Message-----
From: Weaver, Walt [mailto:wweaver_at_rightnow.com] Sent: 15 December 2000 14:17
To: Multiple recipients of list ORACLE-L Subject: RE: Character sets

No, it can be done. WE8ISO8859P1 is a superset of US7ASCII, so the characterset change is no problem.

And, WE8ISO8859P1 allows accented characters. We're running a German interface on one of our databases.

Happy Holidays,

--Walt Weaver
Bozeman, Montana, USA

-----Original Message-----
Sent: Friday, December 15, 2000 5:37 AM
To: Multiple recipients of list ORACLE-L

Hi,

There is not.=20
You must export, rebuild and import.

Another thing, I'm not sure but I think that WE8ISO8859P1 does not allow the Euro symbol.

HTH
--- lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk> a =E9crit=A0: > All,
> =20
> I have been made aware of a problem at our site.
> =20
> Apparently we have a DB that was historically
> created with the wrong
> character set. It should be WE8ISO8859P1 but has
> been set at US7ASCII. The
> DB needs to be able to support German characters
> (such as =FC, =F6, =DF). Please
> tell me there is a way around this other than
> recreating the entire database
> (it is a fairly large DB).
> =20
> TIA=20
> =20
> Lee Robertson=20
> Acxiom=20
> Tel: 0191 525 7344=20
> Fax: 0191 525 7007=20
> Email: lerobe_at_acxiom.co.uk=20
> =20

>=20
>=20

> The information contained in this communication is
> confidential, is intended only for the use of the
> recipient
> named above, and may be legally privileged. If the
> reader=20
> of this message is not the intended recipient, you
> are
> hereby notified that any dissemination, distribution
> or
> copying of this communication is strictly
> prohibited. =20
> If you have received this communication in error,
> please=20
> re-send this communication to the sender and delete
> the=20
> original message or any copy of it from your
> computer
> system.
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: lerobe - Lee Robertson
> INET: LEROBE_at_acxiom.co.uk

>=20

> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).

=3D=3D=3D=3D=3D
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Weaver, Walt
INET: wweaver_at_rightnow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader=20 of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. =20 If you have received this communication in error, please=20 Received on Fri Dec 15 2000 - 09:30:41 CST