RE: Which Character set?

I'd like to know about these pains also, as we are using UTF8 on all our AIX 4.3.3, 8.1.7.0 e-commerce databases w/o any major problems; all of which were converted from WE8ISO8859P1.   The only problem we've really encountered thus far is a compatibility issue with the 3rd-party AUTOSYS scheduling tool, which apparently cannot have it's repository reside in a UTF8 database.  

Thanks,
Jeff T.

-----Original Message-----
From: Cherie_Machler_at_gelco.com [mailto:Cherie_Machler_at_gelco.com] Sent: Wednesday, January 16, 2002 2:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: Which Character set?

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 <ORACLE-L_at_fatcity.com>      

                    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).