How to save non-English text in sql server?

Question

I am trying to develop one desktop application which takes input in hindi from a textbox and saves it into a sql server database.

The textbox font is set to hindi. When I try inserting the hindi text into SQL Server it throws an error on cmd.ExecuteNonQuery(Invalid operation).

How can I insert hindi text into sql server?

What is the data type of your column in which text will be stored? Also, what is the exception you are getting? — npinti, Apr 27 '15 at 08:14
@npinti I am not remember it but it throws error on cmd.ExecuteNonQuery — NitinTurankar, Apr 27 '15 at 08:22
The error you are getting is vital in helping us help you solve the problem. Without it we cannot do much. I'd recommend you close the question and ask a new one when you have the stack trace at hand. What vendor and version of the Database you are using will also help. — npinti, Apr 27 '15 at 08:24

score 1 · Answer 1 · edited Apr 13 '17 at 12:42

1

NVARCHAR datatype is the best possible way to handle multi linguistics.

Please find some of the links below for your reference.

edited Apr 13 '17 at 12:42

Community

answered Apr 27 '15 at 08:26

Praveen_07

I need textbox value to be inserted in sql server through IDE not direct sql server query – NitinTurankar Apr 27 '15 at 08:34
1

What do you mean "through IDE"? The textbox doesn't exist in the IDE, it exists in the running program. – John Saunders Apr 27 '15 at 17:02
@JohnSaunders I got solution :) – NitinTurankar Apr 30 '15 at 14:16

1 Answers1