ASP - UTF Support

Question

0.00/5 (No votes)

See more:

I have an application that has both classic ASP and .Net 2.0.

UTF-8 characters like Chinese and Japanese characters can be retrieved from database and store it as well.

I have problem with classic ASP, I could type UTF-8 or cut and paste also no problem. However, when I retrieve from Oracle 11g database using same Oracle 11 client not able to display, it appears as 'upside down question mark'.

Any help is appreciated.

Posted 13-Dec-10 10:15am

RajaSivalingam

Updated 13-Dec-10 10:57am

Henry Minute

v2

Add a Solution

Comments

Venkatesh Mookkan 13-Dec-10 22:08pm

Is the Database has the Unicode values by default, or you insert them from your ASP application?

Seems like the inserted record is not stored as the Unicode values. In SQL Server we used to put a "N" in front of the data to insert the Unicode value. Check the same for Oracle too.

RajaSivalingam 13-Dec-10 23:12pm

I am using Oracle 11g and supports UTF-8, I was able to save and retrive the same using .Net. I am not able to retrieve the same using classic ASP.

RajaSivalingam 13-Dec-10 23:13pm

BTW, Thanks for your reply.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Alper Hankendi · Answer 1 · 2011-01-26T08:06:00

Solution 1

Did you check support character codepage on ur database or table ?

Posted 26-Jan-11 8:06am

Alper Hankendi