如何将阿拉伯字符插入SQL数据库？
如何将阿拉伯字符插入 SQL Server 数据库？我尝试将阿拉伯数据插入表中，插入脚本中的阿拉伯字符在表中插入为 '??????' 。
我尝试通过SQL Server Management Studio直接将数据粘贴到表中，阿拉伯字符成功且准确地插入。
我四处寻找此问题的解决方案，一些线程建议将数据类型更改为 nvarchar 而不是 varchar。我也尝试过这个，但没有任何运气。
如何将阿拉伯字符插入SQL Server数据库？
How can I insert Arabic characters into a SQL Server database? I tried to insert Arabic data into a table and the Arabic characters in the insert script were inserted as '??????' in the table.
I tried to directly paste the data into the table through SQL Server Management Studio and the Arabic characters was successfully and accurately inserted.
I looked around for resolutions for this problems and some threads suggested changing the datatype to nvarchar instead of varchar. I tried this as well but without any luck.
How can we insert Arabic characters into SQL Server database?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
为了使字段能够存储 unicode 字符，您必须使用
nvarchar类型（或其他类似的类型，如ntext、nchar）。要在数据库中插入 unicode 字符，您必须使用
nvarchar/SqlDbType.NVarChar等参数类型将文本作为 unicode 发送。（为了完整起见：如果您动态创建 SQL（违反常见建议），请在字符串文字前放置一个 N 以使其成为 unicode。例如：
insert into table (name) values (N'Pavan').)For the field to be able to store unicode characters, you have to use the type
nvarchar(or other similar likentext,nchar).To insert the unicode characters in the database you have to send the text as unicode by using a parameter type like
nvarchar/SqlDbType.NVarChar.(For completeness: if you are creating SQL dynamically (against common advice), you put an N before a string literal to make it unicode. For example:
insert into table (name) values (N'Pavan').)我认为解决方案是首先将字段设置为
ntext，然后写入N后跟值。例如：I think the solution is to first set the field to
ntext, then writeNfollowed by the value. For example:如果您像我一样尝试将数据直接加载到数据库中，我找到了一个很好的方法，即使用 Excel 创建表格，然后导出为 CSV。然后我使用数据库浏览器SQLite将数据正确导入到SQL数据库中。然后，您可以根据需要调整表属性。希望这会有所帮助。
If you are trying to load data directly into the database like me, I found a great way to do so by creating a table using Excel and then export as CSV. Then I used the database browser SQLite to import the data correctly into the SQL database. You can then adjust the table properties if needed. Hope this would help.