Red Hat Bugzilla – Bug 21201
Problem with Oracle and Web importing foreign characters
Last modified: 2015-01-07 18:42:40 EST
There seems to be a recurrance of foreign characters not importing properly
from the web into Oracle.
The following order: 3111741 from web order W2200617 imported with the
"SVERRIR C LAFSSON" it should have been "...OLAFFSON"
I beleive there was an O with an 'umlaut' (the 2 little dots above a
letter) in the original customer name and somewhere along the line, an
interface corrupted this value to an invalid
character --(a square block)-- in the name field.
Can this be fixed???
I have since changed the information, Customer Name and Contact name on Account
I just over-typed the correct information, hopefully deleting the corrupted
character. Hopefully the order will go now.
If you look at the web_user_personal_info table for this user (464319), you
will see the following:
When I cut-n-paste into the bugzilla screen it converts it to:
It appears to be getting imported into oracle as the 1st case above.
Here is yet another example of corrupted characters...
His proper name should be: Mindez Guido Josi Angel
Information for customer: mguido-RH2000
Status update on this issue? Thanks :-)
According to the Oracle reference: "All character data in the version 8 database
is assumed to be in the character encoding scheme specified in the CREATE
DATABASE command that created the database."
I really don't know what this is.
The NLS LANG variable also has something to do with it. I seem to remember Paul
Lindner saying that the web tables supported UTF8, which should be able to deal
with the above cases.
Dealing with this same issue elsewhere.