Special character display in UI

Question

2.00/5 (1 vote)

See more:

I am writing an application(C#) for a specific Character like science symbol(μo).In Oracle DB store properly. This application involves using DataAdapter, OLEDB Connection (oracle 11g)and the DataSet. when i am displaying data in UI. Instead of displaying the correct characters the application displays æo ("æo"). Thanks in advance

Posted 7-Aug-14 21:32pm

vbhorhari

Add a Solution

Comments

Sergey Alexandrovich Kryukov 8-Aug-14 3:52am

You can display every character which has visible glyph. None of them are too "special". :-)
—SA

2 solutions

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)

*Suvabrata Roy* · Answer 1 · 2014-08-07T21:38:00

Solution 2

Hi,

Its a clear problem of character encoding.

how to solve it : change the AppDomain culture to which the character exists. ref
http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo.defaultthreadcurrentuiculture(v=vs.110).aspx[^]

but if you want to stay in same culture but still want to show those character then change the encoding ref : http://msdn.microsoft.com/en-us/library/ms404377(v=vs.110).aspx[^]

Chose your required encoding.

How to use encoding : http://stackoverflow.com/questions/5864272/understanding-text-encoding-in-net[^]

Posted 7-Aug-14 21:38pm

Suvabrata Roy

Comments

vbhorhari 8-Aug-14 3:53am

Following is my code to fetch data from DB.
using (OracleConnection cn = new OracleConnection(connectionString))
{
using (OracleCommand cmd = new OracleCommand(commandText, cn))
{
OracleDataAdapter da = new OracleDataAdapter();
cmd.Connection = cn;
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
foreach (var param in parameters)
{
cmd.Parameters.Add(param.Item1, OracleDbType.Varchar2).Value = param.Item3;

}
da.SelectCommand = cmd;
da.Fill(dt);
}
}
after fill dt, I have checked dt.
It is showing wrong character "æo".

Suvabrata Roy 8-Aug-14 3:57am

set the encoding at the control which you bind the DataTable

vbhorhari 8-Aug-14 4:36am

How to encode?

Suvabrata Roy 8-Aug-14 4:54am

you are not required to encode anything you need set the Encoding type
ref : http://stackoverflow.com/questions/12056030/c-sharp-datagridview-unicode-character-encoding

Sergey Alexandrovich Kryukov 8-Aug-14 3:55am

Basically, it's correct, but the last link is not very good. It's better to read about Unicode in Wikipedia and/or Unicode.org.
I voted 4, if you don't mind.
—SA

Suvabrata Roy 8-Aug-14 3:56am

Thanks sir...
I will not mind...

SRK90 · Answer 2 · 2014-08-07T21:37:00

Solution 1

Set the webclient encoding to UTF8.

client.Encoding = System.Text.Encoding.UTF8;

Please refer this link[^] too

Happy Coding :)

Posted 7-Aug-14 21:37pm

SRK90

Updated 7-Aug-14 21:39pm

v2