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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
