Ron,
Thanks for taking time to provide this detailed reply. It is quite
helpful.
Cherie Machler
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 01:56
PM
Please respond
to ORACLE-L
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).
--
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).
