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 Customer name: "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 # 274263. I just over-typed the correct information, hopefully deleting the corrupted character. Hopefully the order will go now. -Jeff
If you look at the web_user_personal_info table for this user (464319), you will see the following: C-rlafsson When I cut-n-paste into the bugzilla screen it converts it to: Crlafsson 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 -Jeff Customer information Information for customer: mguido-RH2000 User ID mguido-RH2000 Password RH24636rh First name Guido Josgngel Last name Mh-$ez e-mail mguido
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.