how to save data in hindi font to ms sql data base from a textbox/

Question

hi ,,,

i am using c# windows application.

i want to insert data in Hindi fount from some text boxes to ms sql database but when i take kruti dev fount to insert data it inserted English fount instead of hindi char how to do this please help.....  

Answer 1

Change the type of table field to nchar/nvarchar/ntext to support unicode charset.

---

It all Happenz Sendil

Answer 2

i am using nvarchar but don't know how to take unicode charset from textbox.....

Answer 3

Related to your question is in this forum only one reply possible. 

If your Hindi text is visible in your Textbox then

var MyDataField = MyTextBox.Text;

For VB users seeing this reply. 

change var for dim and remove the semicolon

---

Success
Cor

Answer 4

i am using kruti dev 10 fount for text boxes , it shows hindi on run time in tex box  but insert english in database....

Answer 5

If you copy the text from database back to textbox (e.g. manually via Clipboard) and see a correct Hindi text, then there is no problem with database. You probably see English letters when a different font is used. The fonts are not stored to database together with the text.

Probably Kruti Dev 010 is a non-Unicode font that replaces English characters.

Answer 6

What kind of textbox are you using, maybe a RichTextbox?

Then we are not talking about the same.

---

Success
Cor