Given- - Oracle Applications 11.5.4 - HPUX 11.0 - Support for English, Brazilian Portuguese, and Simplied Chinese required UTF8 - DB, forms, reports, and Apache servers all run with NLS_LANG=American_America.UTF8
Problems- - Any Oracle reports generated require printing via a utility called pasta to handle the UTF8 characters. - Any sql*plus reports will need to be either filtered using iconv to convert to a code set that the printer understands, or a convert( column, 'WE8ISO8859P1') function will need to used for ever column on the extract. - Dev 2000 patch set 6 cleared up a lot of initial problems with forms. - We still have some nagging java codeset exceptions when a form is generated as UTF8. The biggest issue is with the 3 tier archetecture, and the servers running UTF8, the data returned from the database is going to coded UTF8. No printer that I know of supports this encoding and it must first be converted before printing. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] "Hit any PHB to continue..." Cherie_Machler @gelco.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Which Character set? om 01/16/02 12:05 PM Please respond to ORACLE-L Ron, Can you elaborate on the "pains" you are having getting UTF8 working correctly? We are preparing to convert some databases to UTF8. I'd appreciate any specific details that you can provide. We are using 8.1.7.2 and 9.0.1 on Sun Solaris 2.6. Cherie Machler Oracle DBA Gelco Information Network "Ron Thomas" <rthomas@hyper To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> com.com> cc: Sent by: Subject: Re: Which Character set? [EMAIL PROTECTED] om 01/16/02 10:55 AM Please respond to ORACLE-L Unless you have the need to support other languages other than English or need to support characters like the Euro, don't bother. You would not believe the pains we are having here trying to get UTF8 working correctly... WE8ISO8859P1 or P15 might be a choice for you. See what other listers have to say. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] "Hit any PHB to continue..." [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: root@fatcity. Subject: Which Character set? com 01/16/02 08:56 AM Please respond to ORACLE-L I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I should be using one of the newer character sets. Is there a newer character set that would still work with the old application data? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Ron Thomas 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: Ron Thomas 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).