Printable View
My SQL Server is dsplaying Unicode Characters.
I want to insert Hindi in SQL from .Net, I am sending the Text "sonia"(IN ENGLISH) with N Before it.Code:declare @demo nvarchar(100)
set @demo = N'यह एक'
select @demo
Code: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!!!
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.
You're forgetting the rtb which will let you use as many different fonts as you like.Quote:
Originally Posted by dunfiddlin
@ sonia: When saving to SQL, use the rtb's rtf property + not its text property
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?Quote:
Originally Posted by sonia.sardana
Yes you are Right.. Is that possible???
Quote:
Originally Posted by formlesstree4
Tell me, how would the server know to translate your text?Quote:
Originally Posted by sonia.sardana
OK. So we need to send hindi from .Net code too...Quote:
Originally Posted by formlesstree4
Is that possible suppose I type SONIA (ENGLISH) in textbox, it will convert to सोनिया in textbox, as we leave the textbox.
OK. So we need to send hindi from .Net code too...Quote:
Originally Posted by formlesstree4
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.Quote:
Originally Posted by sonia.sardana
I dont want to use Google Translate , because Internet Connection is Required while using Google Translate...Quote:
Originally Posted by formlesstree4
I want the string to be converted without using IE connection.
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?
The N' prefix is asking SQL to use the DEFAULT CODE PAGE for the database to perform Unicode processingQuote:
Originally Posted by dunfiddlin
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! :D ] data type.Quote:
Originally Posted by szlamany
Source: I use SQL all the time!