Re: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!!!

From: <tday6_at_csc.com>
Date: Wed, 09 Jan 2002 05:59:02 -0800
Message-ID: <F001.003EAEB0.20020109053523@fatcity.com>

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            <ORACLE-L_at_fatcity.com>                        
    
                    @fcg.com>            cc:                                           
    
                    Sent by: root        Subject:     US7ASCII, UTF8, characters sets, 
    
                                         conversions.....agghhhhHH!!!!!                
    
                                                                                       
    
                    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=5310&v_trx=784353

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
  INET: cgrabowy_at_fcg.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: tday6_at_csc.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 09 2002 - 07:59:02 CST