Guajarti text not displaying in sql when inserted from ASP.NET

Question

0.00/5 (No votes)

See more:

Hello everyone,

I have one query regarding language text insertion in sql from ASP.NET.

I have setup the gujarati text using regional language in windows 7 , now when I insert text in gujarati in asp.net webform textbox it is inserted in the textbox but when I fire query to insert into database in sql it gives me text like ?
I have kept datatype of the sql column varchar(max) and also nvarchar(50),but it was not possible to insert it was showing me ?

Please guide me how is it possible to insert gujarati text into sql fields from ASP.NET

Thanks & Regards,
Krunal Panchal

Posted 24-Mar-11 4:35am

krunal25

Updated 24-Mar-11 4:39am

Sandeep Mewara

v2

Add a Solution

Comments

Sandeep Mewara 24-Mar-11 10:55am

Like what? You missed the part.

[no name] 25-Mar-11 1:00am

Plz give error details.

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)

Henry Minute · Accepted Answer · 2011-03-24T05:26:00

Solution 1

In order for SqlServer columns to accept unicode characters they must be preceded by an uppercase 'N'.

For example: (in English, I don't speak Gujerati :) )
TextBox.Text = Hello there.
To insert as unicode (pseudo SQL)

SQL

SET InputPhrase = N'Hello there.'

Hope this helps.

Posted 24-Mar-11 5:26am

Henry Minute

Comments

[no name] 25-Mar-11 1:35am

thanks a lot buddy your answer worth me a lot :)
Once again i thank you , you were really helpful..
Krunal Panchal