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