Re: Extended Characters

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 13 Apr 2004 14:40:28 -0400
Message-Id: <s07bfbe9.077@galottery.org>

Deanna,
the =BF is created by holding down the "Alt" key and hitting number 168. = Perhaps there is a conversion error in the application that generates = those key strokes.
Ron

>>> deanna.schneider_at_ces.uwex.edu 04/13/2004 1:22:01 PM >>>
Hi All,
I'm just a lowly developer, so bear with me, please. We do a lot of development with web applications (using ColdFusion) that insert data = using
the jdbc drivers into Oracle (8.1.7). These are the language variables in Oracle. Supposedly, they've been set to match in the java server, too:

NLS_LANGUAGE - American
NLS_TERRITORY - America
NLS_CHARACTERSET - WE8DEC (an extended character set, Western

European)

We have a recurring problem with the Microsoft Extended Characters turning into upside down question marks on insert. The DBA and Coldfusion admins say, "there's nothing that can be done."

The recommended hack is to change all extended characters to their html entities before insert - which works fine if you're using the data only on webpages. Not such a good approach if you want it for other stuff - like downloadable spreadsheets and such.

Can you think of anything that could be done?

--=20
Deanna Schneider
UWEX-Cooperative Extension
Interactive Media Developer

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

To unsubscribe send email to: oracle-l-request_at_freelists.org=20 put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/=20
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=20
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Apr 13 2004 - 14:36:24 CDT