RE: Spooling data containing Umlaut character (DB characterset UTF8)

From: Ron/Sarah Yount <ronwy_at_SWBELL.NET>
Date: Fri, 13 Sep 2002 17:13:19 -0800
Message-ID: <F001.004D006B.20020913171319@fatcity.com>

Karthik,

I will spare you the details, but here is the deal,

1) You set your client NLS_LANG to AMERICAN_AMERICA.UTF8
2) You insert 'MÜNCHEN' into your database.
3) On the way, your OS is set to a different character set (WE8MSWIN1252

on Windows default) so a translation occurs 4) So data that is 1252 based is given to oracle db with client setting of UTF8, which tells oracle NO conversion is required since it is also UTF8 based, so it performs the UTF8 encoding and stores the data. 5) When you ask to see it back, it is not what you expected.

You can cure this.... Change your client setting to something that supports the umlaut such as WE8MSWIN1252, start sqlplus, do your insert, commit, and subsequent select and it will look fine.

If the data already exists, change your charcterset (NLS_LANG on the client), start sqlplus, select the data (spool in your case) and it should work fine. Oracle has the data stored in a universal code Unicode and has encoded it with UTF8. If it has a legitimate character set for your client NLS_LANG, then it will un-encode it, translate the Universal code to the proper code point for you client and all is well.

Let me know if you need more information or assistance.

HTH,
-Ron-

-----Original Message-----

Karthikeyan S
Sent: Friday, September 13, 2002 2:13 AM To: Multiple recipients of list ORACLE-L UTF8) Hi,
We are trying to extract the data from the oracle database 8.1.7. which contains special characters like umlaut. The Characterset of Oracle db is UTF8 and the Character set at Client side is AMERICAN_AMERICA.UTF8. While we spool the data from the Oracle db an extra space (byte) is added if umlaut character exists. For example : 'MÜNCHEN' - If we query the size it shows 7 bytes but while spooling to a flat file it takes 8 bytes. This problem exists only when the umlaut character and normal character exists like the above eg. If data contains only umlaut then we dont get this problem. Any info on this would be of great help.

regards,
Karthik
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Karthikeyan S
INET: skarthik_at_globalsw-in.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/Sarah Yount
INET: ronwy_at_SWBELL.NET

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