Can we Type Hindi In Windows Application Textbox

[sonia.sardana]

My SQL Server is dsplaying Unicode Characters.

declare @demo nvarchar(100)
set @demo = N'यह एक' 
select @demo

I want to insert Hindi in SQL from .Net, I am sending the Text "sonia"(IN ENGLISH) with N Before it.

cmd = new SqlCommand("INSERT INTO hindi(Name) VALUES (N'sonia')", con);
cmd.ExecuteNonQuery();

IN SQL, sonia is saved in english format only. I want the sonia to insert in HINDI FORMAT(सोनिया ) .. How its possible??

PLEASE HELP ME!!!

[dunfiddlin]

As with any string variable what is stored in any nvarchar field is merely a list of character values. It is not English or any other language, merely a chain of numbers. What turns it into English in any display is the font used in that display. So if you display the value using a Hindi font then it becomes Hindi. There's no magic to that. This does mean that you've given yourself a bit of a problem if you're going to display the prefix 'N' in English and the remainder in Hindi of course because few controls give you the native ability to display more than one font at a time.

[.paul.]

...because few controls give you the native ability to display more than one font at a time.

You're forgetting the rtb which will let you use as many different fonts as you like.
@ sonia: When saving to SQL, use the rtb's rtf property + not its text property

[formlesstree4]

My SQL Server is dsplaying Unicode Characters.

declare @demo nvarchar(100)
set @demo = N'यह एक' 
select @demo

I want to insert Hindi in SQL from .Net, I am sending the Text "sonia"(IN ENGLISH) with N Before it.

cmd = new SqlCommand("INSERT INTO hindi(Name) VALUES (N'sonia')", con);
cmd.ExecuteNonQuery();

IN SQL, sonia is saved in english format only. I want the sonia to insert in HINDI FORMAT(सोनिया ) .. How its possible??

PLEASE HELP ME!!!

Okay, wait, so...you want to send SQL Server the word "Sonia" (IN ENGLISH), and expect it to translate it into the Hindi equivalent? Or am I misunderstanding you?

[sonia.sardana]

Yes you are Right.. Is that possible???

Okay, wait, so...you want to send SQL Server the word "Sonia" (IN ENGLISH), and expect it to translate it into the Hindi equivalent? Or am I misunderstanding you?

[formlesstree4]

Yes you are Right.. Is that possible???

Tell me, how would the server know to translate your text?

[sonia.sardana]

Tell me, how would the server know to translate your text?

OK. So we need to send hindi from .Net code too...

Is that possible suppose I type SONIA (ENGLISH) in textbox, it will convert to सोनिया in textbox, as we leave the textbox.

[sonia.sardana]

Tell me, how would the server know to translate your text?

OK. So we need to send hindi from .Net code too...

Is that possible suppose I type SONIA (ENGLISH) in textbox, it will convert to सोनिया in textbox, as we leave the textbox.

[formlesstree4]

OK. So we need to send hindi from .Net code too...

Is that possible suppose I type SONIA (ENGLISH) in textbox, it will convert to सोनिया in textbox, as we leave the textbox.

Sure. How would you convert it? Would you send a request to, say, Google Translate? I mean, is there a particular reason they can't be inserted in Hindi? I'm legitimately curious as I don't know.

[sonia.sardana]

Sure. How would you convert it? Would you send a request to, say, Google Translate? I mean, is there a particular reason they can't be inserted in Hindi? I'm legitimately curious as I don't know.

I dont want to use Google Translate , because Internet Connection is Required while using Google Translate...
I want the string to be converted without using IE connection.

[szlamany]

Converted and Translated are two completely different things.

Are you saying that SONIA - a 5 character word - is also 5 characters in Hindi - and that each character S, O, N, I and A map to particular characters in Hindi?

[szlamany]

. This does mean that you've given yourself a bit of a problem if you're going to display the prefix 'N' in English and the remainder in Hindi of course because few controls give you the native ability to display more than one font at a time.

The N' prefix is asking SQL to use the DEFAULT CODE PAGE for the database to perform Unicode processing

http://databases.aspfaq.com/general/...-n-prefix.html

I would not imagine the N would appear in the text box - although this post seems otherworldly already

[formlesstree4]

The N' prefix is asking SQL to use the DEFAULT CODE PAGE for the database to perform Unicode processing

http://databases.aspfaq.com/general/...-n-prefix.html

I would not imagine the N would appear in the text box - although this post seems otherworldly already

As szl said, the N prefix to a string in T-SQL usually stands for either default code page or that the string is a Unicode string. It has no effect on the display when the text is returned, although you usually pair up the N prefix with an "NVARCHAR" or "NCHAR" [ even "NTEXT", but that's going away! ] data type.

Source: I use SQL all the time!