| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Which Character set?
Ron,
Thanks for taking time to provide this detailed reply. It is quite helpful.
Cherie Machler
Gelco Information Network
"Ron Thomas"
<rthomas_at_hyper To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
com.com> cc:
Sent by: Subject: Re: Which Character set?
root_at_fatcity.c
om
01/16/02 01:56
PM
Please respond
to ORACLE-L
Given-
- Oracle Applications 11.5.4
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.
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
rthomas_at_hypercom.com
"Hit any PHB to continue..."
Cherie_Machler
@gelco.com To: ORACLE-L_at_fatcity.com
Sent by: cc:
root_at_fatcity.c 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_at_hyper To: Multiple recipients of
list ORACLE-L
com.com> cc:
Sent by: Subject: Re: Which Character
set?
root_at_fatcity.c
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
rthomas_at_hypercom.com
"Hit any PHB to continue..."
rlsmith_at_kmg.c
om To: ORACLE-L_at_fatcity.com
Sent by: cc:
root_at_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: rlsmith_at_kmg.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: Ron Thomas INET: rthomas_at_hypercom.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: Cherie_Machler_at_gelco.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: Ron Thomas INET: rthomas_at_hypercom.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: Cherie_Machler_at_gelco.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).Received on Wed Jan 16 2002 - 15:00:02 CST
 |
 |