Solved

Oracle 11g storing upside down ? for Special Characters

Posted on 2011-03-17
5
2,616 Views
Last Modified: 2012-06-21
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/editlive.css" rel="stylesheet" type="text/css">
<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>&nbsp;</p>

<p>spanish character ã</p>

<p>&nbsp;</p>

<p>quotation mark "this is inside quotes"</p>

<p>&nbsp;</p>

<p>apostrophe - Who's Who</p>

<p>&nbsp;</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>&nbsp;</p>

<p>spanish character ã</p>

<p>&nbsp;</p>

<p>quotation mark "this is inside quotes"</p>

<p>&nbsp;</p>

<p>apostrophe - Who's Who</p>

<p>&nbsp;</p>

<p>&nbsp;</p>


Thanks for your help.   I am attaching the EditLive Config file but I really think this is an Oracle issue.
0
Comment
Question by:cmlane08
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 7

Expert Comment

by:Piloute
ID: 35158302
Hi,

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
0
 

Author Comment

by:cmlane08
ID: 35158382
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.
0
 
LVL 7

Accepted Solution

by:
Piloute earned 500 total points
ID: 35158470
Unfortunately for you, there's no SQL to change a characterset. Upgrading a characterset is a real dba action, and not a simple query. Is your database big ? You could export all your database, recreate an empty one with the right caraterset, then import the exported base. It is the 'simplest' solution I can suggest...

I don't know EditLive, but I assume it is a windows based app. So It will use your Windows settings (includins character encoding). Changing on this side, is not the right thing to do :

- you would mess your Windows settings

- you would STILL NOT store the right thing in the database. It is the database that has to understant what you want to store. In this case, you speak spanish to the spanish guy, but you ask him to write it in chinese... The result will be the same as previously...

P
0
 

Author Closing Comment

by:cmlane08
ID: 35160416
Thanks for the information!
0
 
LVL 7

Expert Comment

by:Piloute
ID: 35165476
welcome !
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question