storing Hindi value into database

Question

0.00/5 (No votes)

See more:

ASp.net application Hindi to unicode convertion problem

Sir i have a .aspx page, there i have text box, which have hindi font. when i put data from keyboard. the text coming in hindi on text box.

but when iam storing it into string variable, not getting actual value.

also i want to convert that record , which in hindi to unicode. then want to store it into database.

someone plzzzzz help, got struck.

Posted 20-Nov-12 22:05pm

Sanjay_ji

Add a Solution

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)

Sanjay_ji · Answer 1 · 2012-11-20T22:21:00

Solution 1

anyone please give me the solutions

Posted 20-Nov-12 22:21pm

Sanjay_ji

Rai Pawan · Answer 2 · 2012-11-20T22:25:00

Solution 2

Sanjay

C#.net string type handles unicode, however make sure that you are storing the data in either nvarchar or ntext since varchar and text don't handle unicode data.

The other thing is while displaying the data on a page set text encoding to utf like
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

Regards
Pawan

NOTE: please mark the answer as accepted if it fits your criteria

Posted 20-Nov-12 22:25pm

Rai Pawan

Comments

Sanjay_ji 21-Nov-12 4:40am

thanks Mr. Rai Pawan,
But this is not what exactly i want

here is the code

<asp:TextBox ID="subject" runat="server" Font-Names="Arjun" AutoPostBack="True" ontextchanged="subject_TextChanged">

protected void subject_TextChanged(object sender, EventArgs e)
{
s = subject.Text;

// how do i get record that store exact value in string , that is in Textbox front end, when i type राम from keyboard, it show jke value on screen. please help +91 9580386241
}

Rai Pawan 21-Nov-12 7:20am

Even then you will have to set the encoding at the time of displaying the string, so get the string in s variable Encoding.UTF8 while displaying.