RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!
Sorry, forgot the start. It is :WE8ISO8859P1. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [SMTP:[EMAIL PROTECTED]] Sent: Thu, January 10, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: US7ASCII, UTF8, characters sets, conversions.aggHH!!! Hello Chris We are using ISO8859P1 because we need support for Hebrew character set. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] Sent: Wed, January 09, 2002 5:45 PM To: Multiple recipients of list ORACLE-L Subject:RE: US7ASCII, UTF8, characters sets, conversions.aggHH!!! 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 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wed, January 09, 2002 3:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: US7ASCII, UTF8, characters sets, conversions.aggHH! 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[EMAIL PROTECTED] @fcg.comcc: Sent by: rootSubject: US7ASCII, UTF8, characters sets, conversions.aggHH! 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=5310v_trx=784353 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself
RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!
Ok, so to get a better feel for what's going on, is everyone still using US7ASCII?? Have sites started switching over to UTF8?? Have there been any conversion problems?? Do the websites(like Amazon, Yahoo, BN, etc) that have an Oracle backend enforce UTF8 as a standard, so that they can store any type of character that a user enters??? -Original Message- Sent: Tuesday, January 08, 2002 4:05 PM To: Multiple recipients of list 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_tech_ content_phy_Id=5310v_trx=784353 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Grabowy, Chris 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).
RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!
Chris, We have started using UTF8 on our new databases as a standard. All of our old, existing databases use US7ASCII. We need to convert a couple of existing databases such as our 200Gig data warehouse from US7ASCII to UTF8. I am concerned about conversion problems. I asked a few weeks ago if anyone had successfully converted from US7ASCII to UTF8 but got no response. I've searched on Metalink for the topic and didn't find much. If you get any responses, could you forward them on to me or post to the list. Thanks much, Cherie Machler Oracle DBA Gelco Information Network Grabowy, Chris To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cgrabowy@fcg. cc: com Subject: RE: US7ASCII, UTF8, characters sets, Sent by: conversions.aggHH!!! [EMAIL PROTECTED] om 01/10/02 07:35 AM Please respond to ORACLE-L Ok, so to get a better feel for what's going on, is everyone still using US7ASCII?? Have sites started switching over to UTF8?? Have there been any conversion problems?? Do the websites(like Amazon, Yahoo, BN, etc) that have an Oracle backend enforce UTF8 as a standard, so that they can store any type of character that a user enters??? -Original Message- Sent: Tuesday, January 08, 2002 4:05 PM To: Multiple recipients of list 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_tech_ content_phy_Id=5310v_trx=784353 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Grabowy, Chris 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
RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!
Look at 1. Note 139654.1 Oracle Applications Release 11i with UTF8 FAQ 2. Note 124721.1 Migrating an Application Installation to a new character-set [UTF8] 3. Note 134375.1 Using UTF8 Character Set with Applications Release 11i Even if you are not running Oracle Apps, I suggest you read these notes. [I haven't done a conversion -- I am running US7ASCII and WE8ISO8859P1 databases ony :( ] Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [EMAIL PROTECTED] 10/01/2002 10:05 PM Sent by: [EMAIL PROTECTED] Chris, We have started using UTF8 on our new databases as a standard. All of our old, existing databases use US7ASCII. We need to convert a couple of existing databases such as our 200Gig data warehouse from US7ASCII to UTF8. I am concerned about conversion problems. I asked a few weeks ago if anyone had successfully converted from US7ASCII to UTF8 but got no response. I've searched on Metalink for the topic and didn't find much. If you get any responses, could you forward them on to me or post to the list. Thanks much, Cherie Machler Oracle DBA Gelco Information Network Grabowy, Chris To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cgrabowy@fcg. cc: com Subject: RE: US7ASCII, UTF8, characters sets, Sent by: conversions.aggHH!!! [EMAIL PROTECTED] om 01/10/02 07:35 AM Please respond to ORACLE-L Ok, so to get a better feel for what's going on, is everyone still using US7ASCII?? Have sites started switching over to UTF8?? Have there been any conversion problems?? Do the websites(like Amazon, Yahoo, BN, etc) that have an Oracle backend enforce UTF8 as a standard, so that they can store any type of character that a user enters??? -Original Message- Sent: Tuesday, January 08, 2002 4:05 PM To: Multiple recipients of list 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_tech_ content_phy_Id=5310v_trx=784353 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Grabowy, Chris 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: 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: INET: [EMAIL PROTECTED] Fat City Network Services--
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[EMAIL PROTECTED] @fcg.comcc: Sent by: rootSubject: US7ASCII, UTF8, characters sets, conversions.aggHH! 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_tech_ content_phy_Id=5310v_trx=784353 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: 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).
RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!
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 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wed, January 09, 2002 3:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: US7ASCII, UTF8, characters sets, conversions.aggHH! 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[EMAIL PROTECTED] @fcg.comcc: Sent by: rootSubject: US7ASCII, UTF8, characters sets, conversions.aggHH! 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=5310v_trx=784353 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 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: [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).
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 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wed, January 09, 2002 3:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: US7ASCII, UTF8, characters sets, conversions.aggHH! 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[EMAIL PROTECTED] @fcg.comcc: Sent by: rootSubject: US7ASCII, UTF8, characters sets, conversions.aggHH! 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=5310v_trx=784353 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 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: [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: Grabowy, Chris 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).
RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!
if you attended IOUG and had a user/pwd it would, yea. thanks -Original Message- Sent: Tuesday, January 08, 2002 4:05 PM To: Multiple recipients of list 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_tech_ content_phy_Id=5310v_trx=784353 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Mohan, Ross 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).