How to create Unicode database in Oracle 10g

Question

0.00/5 (No votes)

See more:

Hi All,
How do we create Unicode supported database in Oracle 10g? I have already created a database in Oracle but when I try to insert values in tables, it appears as '?' only.
Your help will be highly appreciable.

Thanks,

Posted 28-Feb-14 17:09pm

RahulMGunjal

Add a Solution

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)

Jörgen Andersson · Answer 1 · 2014-02-28T19:17:00

Solution 1

Best is to install the database (and the clients) with the correct character set[^].

But second best is to swap all Varchar2 columns for NVarchar2[^].

Posted 28-Feb-14 19:17pm

Jörgen Andersson

Comments

RahulMGunjal 3-Mar-14 2:14am

Thanks for reply. I tried second option by coverting Varchar2 to NVarchar but still it shows data as ?. Is there any way to alter the selected tables to support Unicode data as my database has only one table which requires Unicode support.

Jörgen Andersson 3-Mar-14 2:46am

How do you insert the values? If you are using parameters (recommended)you need to specify the field type as NVarChar2. If you insert using a string you must be sure to specify that it is a unicode string by prefixing it with N, like: Insert into MyTable (MyColumn) values (N'MyUnicodeString');

RahulMGunjal 4-Mar-14 0:51am

Tried, still not working!

Jörgen Andersson 4-Mar-14 1:42am

Is the program you're viewing the data in supporting Unicode?