how to store hindi data in sql server 2005

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

VB

SQL-Server

how to store hindi data in sql server 2005 through VB.Net??
Please Help me?

Posted 22-Apr-13 0:51am

Priyanka Jain

Add a Solution

5 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)

Aarti Meswania · Answer 1 · 2013-04-22T01:00:00

Solution 2

In sql table set your column's datatype nvarchar(Max)

and while insert

SQL

insert into tbl(col1) values(N'text')

Happy Coding!
:)

Posted 22-Apr-13 1:00am

Aarti Meswania

Updated 22-Apr-13 1:04am

v2

Comments

Priyanka Jain 22-Apr-13 7:08am

i tried but didnot convert into Hindi...

Ank_ush 26-Aug-13 1:19am

the above answer is correct. But is it possible to view the stored data in sql server in marathi or hindi language whichever (I am using marathi). if possible please let me know....

Aarti Meswania 22-Apr-13 7:12am

it will not convert text in hindi
but it will insert text in hindi

select textbox set it's font hindi now, passtextbox's text in sql query

Aarti Meswania 26-Aug-13 1:32am

yes it will show same data you stored
try this...
declare @demo nvarchar(100)
set @demo = N'विद्या' -- set / insert val.
select @demo -- select (retrive value)

Priyanka Jain 22-Apr-13 7:18am

i set textbox font in hindi and while typing in textbox it displays in hindi but does not save in hindi??what to do?there is any property for Textbox?

Ank_ush 26-Aug-13 1:40am

when i am inserting from textbox and retrieving there is no problem. But my question is that when we fire select query in sql server mgt studio for eg; Select * from Cust_Details, the results are fetched but in english, how can i see in marathi ??

Aarti Meswania 22-Apr-13 7:20am

what is your insert query?

Ank_ush 26-Aug-13 1:43am

Please view this page. In this page the values are inserted from sql server mgt studio not textbox.
http://stackoverflow.com/questions/17786379/unable-to-retrive-marathi-font-text-from-database-in-proper-way-in-asp-net

Priyanka Jain 22-Apr-13 7:25am

INSERT INTO Medicine (Mode_Hindi) VALUES (N'" & txt_hindi.Text & "')

Aarti Meswania 26-Aug-13 2:01am

I think you are not using google language tool...
then make your textbox's fonts marathi.

Aarti Meswania 22-Apr-13 7:27am

what is datatype of column Mode_Hindi in sql?

Priyanka Jain 22-Apr-13 7:28am

nvarchar(Max)

Aarti Meswania 22-Apr-13 7:30am

try below query instead of "INSERT INTO Medicine (Mode_Hindi) VALUES (N'" & txt_hindi.Text & "')"

INSERT INTO Medicine (Mode_Hindi) VALUES (N'एक');

and let me know it work or not

Priyanka Jain 22-Apr-13 7:35am

it inserted. but when i insert through textbox value.it will not work.

Aarti Meswania 22-Apr-13 7:40am

here it is...
cmd.Commandtext = "INSERT INTO Medicine (Mode_Hindi) VALUES (@Mode_Hindi);"
cmd.Parameters.Add("@Mode_Hindi", SqlDbType.NVarChar).Value = txt_hindi.Text ;
cmd.ExecuteNonQuery();

Member 15100152 8-Nov-22 4:45am

I tried your code, but its not working. From vb.net textbox value, the data is stored as english.

Naz_Firdouse · Answer 2 · 2013-04-22T00:59:00

Solution 1

check this...
Save Hindi,Marthi Content in Sql Server database[^]

also refer these
http://aalamrangi.wordpress.com/2012/05/13/storing-and-retrieving-non-english-unicode-characters-hindi-czech-arabic-etc-in-sql-server/[^]

Posted 22-Apr-13 0:59am

Naz_Firdouse

Updated 22-Apr-13 1:04am

v2

*Karthik Harve* · Answer 3 · 2013-04-22T01:05:00

Hi,

In order to store data of hindi or any other language, just make the column datataype as "nVARCHAR" or "nTEXT" or "nCHAR", and pass the values as it is you do normally by using INSERT statements.

refer Ado.net with Localization[^]

you can also refer SQL SERVER 2005 Multiple Language Support[^]

hope it helps.

Hemant Singh Rautela · Answer 4 · 2013-04-22T01:20:00

Solution 4

Hi,
use nvarchar datatype & insert hindi in unicode... so simple
(note: dont use string fuction tostring() or trim() etc... insert as it as )

thank you

Posted 22-Apr-13 1:20am

Hemant Singh Rautela

Updated 22-Apr-13 1:21am

v2

GyaneshNootan · Answer 5 · 2013-07-30T02:58:00

Solution 5

SQL

Below are the step to save and get Unicode character (Any language other than 
 English except some langs) string in database
1) Use nVarchar data type for corresponding field
2) insert values in corresponding column prefixed with capital N as values(N'text')

Posted 30-Jul-13 2:58am

GyaneshNootan

Updated 30-Jul-13 3:00am

v2

Comments

[no name] 30-Jul-13 9:29am

In other words, your solution is just to do what solution 2 says?

GyaneshNootan 31-Jul-13 1:52am

@ThePhantomUpvoter above solution is also true in case of hindi
You just need to write insert query like below
insert into YourTableName(ColName) values(N'भारत')