SQL Server:显示问号的字符 [英] SQL Server : character showing question mark

问题描述

我在ASP.net中使用连接字符串，但它以阿拉伯文形式显示为问号，我该如何将其转换为正常工作.

I'm using connection string in my ASP.net but its showing question mark as my entry in Arabic language, how I can convert the entry to work properly.

<add name="myodbc" 
     connectionString="Provider=SQLOLEDB;Data Source=xxx;Initial Catalog=xxx;User ID=xxx;Password=xxx;" />

推荐答案

只需要在报表中添加'N'

only you need to add 'N' IN STATMENT

insert into [xx].[dbo].[xx] (Name,Email,Telephone,Type_of_donation,donation_country,donation_category,transa‌​ction_time,payment_method,amount,referance_number) values ('','','',N'غير مشروط','xx','','xx','xx','32','16')

我也使用这种方法在SQL数据库中存储阿拉伯语

这篇关于SQL Server:显示问号的字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！