cmlane08
asked on
Oracle 11g storing upside down ? for Special Characters
I am using Ephox EditLive wysiwyg editor. In the EditLive Editor I'm using the following:
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
The values are displayed corrected on the web page when viewing the HTML code but is NOT stored correctly in the Oracle table.
Ephox EditLive Editor Code View:
<html>
<head>
<link href="/kmcms/common/styles
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<meta content="EditLive! 6.7.5.27" name="generator">
</head>
<body>
<p>cl_trademark_test</p>
<p>trademark symbol ™</p>
<p> </p>
<p>spanish character ã</p>
<p> </p>
<p>quotation mark "this is inside quotes"</p>
<p> </p>
<p>apostrophe - Who's Who</p>
<p> </p>
<p></p>
</body>
</html>
In the Oracle table however, the value is somehow converted to an upside ?. See below:
Oracle table value:
<p>cl_trademark_test</p>
<p>trademark symbol ¿</p>
<p> </p>
<p>spanish character ã</p>
<p> </p>
<p>quotation mark "this is inside quotes"</p>
<p> </p>
<p>apostrophe - Who's Who</p>
<p> </p>
<p> </p>
Thanks for your help. I am attaching the EditLive Config file but I really think this is an Oracle issue.
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
The values are displayed corrected on the web page when viewing the HTML code but is NOT stored correctly in the Oracle table.
Ephox EditLive Editor Code View:
<html>
<head>
<link href="/kmcms/common/styles
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<meta content="EditLive! 6.7.5.27" name="generator">
</head>
<body>
<p>cl_trademark_test</p>
<p>trademark symbol ™</p>
<p> </p>
<p>spanish character ã</p>
<p> </p>
<p>quotation mark "this is inside quotes"</p>
<p> </p>
<p>apostrophe - Who's Who</p>
<p> </p>
<p></p>
</body>
</html>
In the Oracle table however, the value is somehow converted to an upside ?. See below:
Oracle table value:
<p>cl_trademark_test</p>
<p>trademark symbol ¿</p>
<p> </p>
<p>spanish character ã</p>
<p> </p>
<p>quotation mark "this is inside quotes"</p>
<p> </p>
<p>apostrophe - Who's Who</p>
<p> </p>
<p> </p>
Thanks for your help. I am attaching the EditLive Config file but I really think this is an Oracle issue.
ASKER
Thanks for the information. Is there a SQL command I can use to quickly change the database character set? I saw a few references on the net to the nls parameter CHARACTERSET.
I am a bit leery about changing the character set on the database because I don't know how it will affect all our data. I would much rather change the characterset within our wysiwyg EditLive editor to match our database but I don't know our current characterset in Oracle 11g.
I am a bit leery about changing the character set on the database because I don't know how it will affect all our data. I would much rather change the characterset within our wysiwyg EditLive editor to match our database but I don't know our current characterset in Oracle 11g.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the information!
welcome !
This is a classical character set issue with oracle database.
The reversed question mark is a default replacement character in Oracle for WE8ISO8859P1 character set. This character set does not contain the 'TM' caracter so if you ask to store anything it doesn't know, it will just replace it with that symbol.
If you want an analogy, it is like asking a spanish guy to write & understand chinese...
I strongly suggest you to change your database characterset to something else, like WE8MSWIN1252 (if your clients are windows based). Then you will be able to store the 'TM' symbol.
Cheers,
P