如何使用c#在sql中插入unicode数据 [英] How to insert unicode data in sql using c#
问题描述
我正在开发一个Windows应用程序,其中输入是马拉地语。我有代码在sql server中插入数据。
I am developing a windows application in which the input is in marathi language. I have the code to insert data in sql server.
create database Test
create table marathi(Names nvarchar(22))
insert marathi SELECT N'नमस्कार' ---- Right Query
insert marathi SELECT 'नमस्कार' ---- Wrong Query
select *from marathi
只需检查一下a在sql中进行bove查询,你会理解它。如果您使用N前缀写入查询,那么在sql中它正确显示数据,但如果不使用N前缀则显示???????在sql server中。
但现在我的问题是我正在尝试从我的窗口应用程序执行相同操作。我编写了以下代码。
just check once the above query in sql, you will understand it. If u write the query using N prefix then in sql it shows the data properly, but if don't use N prefix then it shows ??????? in sql server.
But now my problem is that I am trying to do same from my window application. I wrote the following code.
SqlCommand slc = con.CreateCommand();
slc.CommandText = "Insert into marathi values(@Names)"
slc.Parameters.Add("@Names", SqlDbType.NVarChar, 22);
slc.Parameters["@Names"].Value = textBox1.Text;
slc.ExecuteNonQuery();
它被保存但不是unicode,可以看到正常的字母。
我怎么能实现这个?请帮助....
it is saved but not in unicode, normal alphabets can be seen.
How can I achieve this? Please Help....
推荐答案
看看这里: Insert Hindi,Marathi,Gujarati,Urdu,Persian,Arabic ,泰米尔语和泰卢固语语言SQL Server中使用C#和VB.Net的文本字符 [ ^ ]
更多:
在ASP.NET中使用字符编码 [ ^ ]
使用Unicode编码 [ ^ ]
如何:为ASP.NET网页全球化选择编码 [ ^ ]
Have a look here: Insert Hindi, Marat Gujarati, Urdu, Persian, Arabic, Tamil and Telugu languages Text characters in SQL Server using C# and VB.Net[^]
More:
Using Character Encoding in ASP.NET[^]
Using Unicode Encoding[^]
How to: Select an Encoding for ASP.NET Web Page Globalization[^]
这篇关于如何使用c#在sql中插入unicode数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!