Save Hindi,Marthi Content in Sql Server database

Question

4.00/5 (1 vote)

See more:

Actually I save content in sql server database but content save like ???? format
& when I retrive That content It Show Same ???.Actullay I want Hindi Content To Show In label Text .
Give Any Suggestion.

Posted 26-Dec-11 0:32am

Nilesh Patil Pune

Updated 26-Dec-11 0:33am

v2

Add a Solution

Comments

anushripatil 26-Dec-11 6:33am

try saving the content in utf-8 format ... i guess it shud save also check ur column datattype in db. Please have a look http://www.dotnetfunda.com/articles/article1132-insert-hindi-font-from-aspnet-web-page-to-sql-server-database.aspx
Hope this helps

6 solutions

Solution 1

If this is character data, have you used for example nvarchar[^] and correct collations: http://msdn.microsoft.com/en-us/library/ms144250.aspx[^]

Posted 26-Dec-11 0:34am

Wendelius

Solution 4

Just use NVarchar datatype and "N" before the strine name.

This will definitely solve the problem..

Posted 27-Dec-11 22:26pm

Sachin Suryawanshi

Comments

Member 8632652 16-Feb-13 5:04am

how to retrive hindi text data from sql 2005

avinash9616 7-Nov-16 10:19am

where to put N in c# sql query ?

Solution 5

Used Nvarchar Datatype in qsl database to store hindi data.

Thanks

Devendra kumar 8581823430

Posted 23-Aug-13 22:04pm

softdev85

Comments

[no name] 24-Aug-13 5:58am

Congratulations! Not only have you answered a 2 year old already answered question but you have given the exact same answer as everyone else! Twice!

Or is this just to spam your website and phone number?

Solution 6

Used Nvarchar Datatype in sql database to store hindi data.

Thanks

Devendra kumar 8581823430

www.softdev.co.in

Posted 23-Aug-13 22:05pm

softdev85

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)

Sarvesh Kumar Gupta · Accepted Answer · 2011-12-26T00:40:00

Solution 2

Use N before parameter i.e.

Insert into test(TextName) values(N'@TextName')

and field datatype should be nvarchar(max)

Posted 26-Dec-11 0:40am

Sarvesh Kumar Gupta

v2

Comments

Member 10302764 2-Oct-13 13:53pm

Thank u ++

Kanhaiya Lal Kumawat 9-Aug-14 8:28am

thank you

Kailash_Singh 20-Jun-20 2:25am

thank you,

RajSekhar Alluri 3-Feb-23 6:10am

This won't work, it will save @TextName in DB, if you use N'@TextName'

I think they said 'thank you' without trying the solution.

Vinod Satapara · Accepted Answer · 2011-12-26T00:41:00

Solution 3

Hi,

You have to change the datatype of the column to nvarchar or ntext

Create table Test_Lang

(strText nvarchar(max))

insert into Test_Lang values ( N 'हिन्दी')

Thanks
Vinod

Posted 26-Dec-11 0:41am

Vinod Satapara

Comments

Dholakiya Ankit 24-Aug-13 4:45am

nice 1