ASP.Net/Oracle - International character issue - DBA and Developer advice. Need gurus.

Hello all,

I am having a problem with one of our apps.  Oracle database is set to 32UTF8 character set.  When we type in certain polish characters and some other characters, when coming back to display in my web application the characters get wiped out or show as little boxes or question marks etc.  After a lot of troubleshooting in many of the editors like Toad. SQL Plus etc. the characters were looking like they were not on the letters for example a little tilda or hat on an "S" or a L with a little slash through it.  Not sure what the characters are called but I thought the database was not storing it correct.  However, in PL/SQL Developer if I clicked on the little box to bring up the data it did show the characters fine.  

The datatype is varchar and I did research and find out we should use nvarchar not varchar.  So I changed the field to nvarchar but I am still having the issue that when getting the value from the database it does not look right in the browser at all.  Even in the code behind in some cases it wipes it out.  If I bind it directly to a datagrid it shows little boxes etc. and the characters are not looking right.

I am trying to figure out what I can try as I tried in the web config of my application using in the globization setting the response and request to UTF8 but still no dice.

I am using Entity Framework and it looks like it actually comes back with the characters wiped out when I set the value to a string I see the data coming in is wiping the characters out.  One thing that does work is we have a BLOB field storing the values as XML as well and that works right when I deserialize that field the value I am looking at has the characters correct with the XML field.

Any advice would be appreciated.  I am trying to see what my issue really is at the database level or the app.  I am leaning towards the app display as the values do look like they are storing right.  I thought the nvarchar was the issue but it seems to be the same.
sbornstein2Asked:
Who is Participating?
 
TMarkham1Commented:
0
 
TMarkham1Commented:
Have you tried adding the following META tag in the HEAD tag of your pages?
<meta http-equiv="content-type" content="text/html;charset=utf-8" />

Open in new window

0
 
TMarkham1Commented:
If I had to guess it is a problem on the app side of things. It sounds like the value is being saved in the database correct... just rendered incorrectly in the web browser. The UTF-8 character set shown above includes support for Polish characters.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
sbornstein2Author Commented:
I will try all of these Monday, thanks so much for your input this is a tough one.
0
 
sbornstein2Author Commented:
thanks guys
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.