RE: characterset database

g.g,

The fundamental difference is that US47ASCII is a 7 bit set and WE8ISO8859P1 is an 8 bit set.

The main problems you can potentially encounter are the assumed 8th bit conversion when the
database using the US47ASCII set stores a character like an accented 'e' in the French Alphabet.

When you subsequently retrieve such characters, due to the "mangling" that has taken place
you will "see" some other character that your Client will obtain from its Code Page
for the "mangled" value.

Anyone care to correct me or add to this ?

Martin

-----Original Message-----
Sent: 30 November 2001 08:40
To: Multiple recipients of list ORACLE-L

hi all

we use 2 different character sets on our oracle servers one sap server uses US47ASCII and our delphi-oracle server uses WE8ISO8859P1.
can anyone tell me what the difference is and which problems i can encounter.

g.g. kor
rdw ict groningen
the netherlands

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: GKor_at_rdw.nl

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: Martin Kendall
  INET: m.kendall_at_ntlworld.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).