RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!

Sorry, forgot the start. It is :WE8ISO8859P1.

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: &alef;&dalet;&resh; &yod;&het;&yod;&alef;&lamed; [SMTP:adary_at_mehish.co.il]
> Sent: Thu, January 10, 2002 12:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: US7ASCII, UTF8, characters sets,
> conversions.....agghhhhHH!!!
>
> Hello Chris
>
> We are using ISO8859P1 because we need support for Hebrew character set.
>
> Yechiel Adar, Mehish Computer Services
> adary_at_mehish.co.il
>
> > -----Original Message-----
> > From: Grabowy, Chris [SMTP:cgrabowy_at_fcg.com]
> > Sent: Wed, January 09, 2002 5:45 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: US7ASCII, UTF8, characters sets,
> > conversions.....agghhhhHH!!!
> >
> > Hey Yechiel,
> >
> > Thanks. And which character set is that?
> >
> > Chris
> >
> > -----Original Message-----
> > Sent: Wednesday, January 09, 2002 9:15 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hello Chris
> >
> > We made a point to have all the components (servers and clients and
> db's)
> > in
> > the same character sets.
> >
> > Yechiel Adar, Mehish Computer Services
> > adary_at_mehish.co.il
> >
> > > -----Original Message-----
> > > From: tday6_at_csc.com [SMTP:tday6_at_csc.com]
> > > Sent: Wed, January 09, 2002 3:35 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: US7ASCII, UTF8, characters sets,
> > > conversions.....agghhhhHH!!!!!
> > >
> > > When I connected I got:
> > >
> > > "OWS-05101: Execution failed due to Oracle error -6550"
> > >
> > > Oops! Maybe they have the wrong character set.
> > >
> > >
> > >
> > >
> > >
> > > "Grabowy,
> > >
> > > Chris" To: Multiple recipients
> of
> > > list ORACLE-L
> > > <cgrabowy <ORACLE-L_at_fatcity.com>
> > >
> > > @fcg.com> cc:
> > >
> > > Sent by: root Subject: US7ASCII, UTF8,
> > > characters sets,
> > >
> conversions.....agghhhhHH!!!!!
> > >
> > >
> > >
> > > 01/08/2002
> > >
> > > 04:05 PM
> > >
> > > Please
> > >
> > > respond to
> > >
> > > ORACLE-L
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > So we stumbled upon the white paper...
> > >
> > > WHY WE ARE MOVING OUR DATABASES TO THE UTF8 CHARACTER SET
> > > By David F. Pennington, GlaxoSmithKline
> > >
> > > This white paper raises a potential issue that DBAs might need to be
> > aware
> > > of. Basically, it has to do with certain characters not storing
> > correctly
> > > in the database because of different character sets being used between
> > the
> > > database, client and how the user enters data into the application.
> > >
> > > Has this issue been raised on the list before?
> > >
> > > Basically, were wondering how other DBAs/sites are
> handling/approaching
> > > this
> > > issue.
> > >
> > > Many TIA!!
> > >
> > > Chris
> > >
> > > I believe the below link will get you to the white paper on the IOUG
> > > website.
> > >
> > >
> >
> http://www.ioug.org/ioug_s/REPOSITORY_PKG.REPOSITORY_BUILD_VIEW_FORM?v_tec
> > > h_
> > >
> > > content_phy_Id=5310&v_trx=784353
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Grabowy, Chris
> > > INET: cgrabowy_at_fcg.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).
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: tday6_at_csc.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).
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > > This e-mail was scanned by the eSafe Mail Gateway
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> > INET: adary_at_mehish.co.il
> >
> > 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Grabowy, Chris
> > INET: cgrabowy_at_fcg.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).
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > This e-mail was scanned by the eSafe Mail Gateway
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> INET: adary_at_mehish.co.il
>
> 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).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?&alef;&dalet;&resh;_&yod;&het;&yod;&alef;&lamed;?  INET: adary_at_mehish.co.il

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).