sql中存储阿拉伯文本时出现问题 [英] problem while storing arabic text in sql

问题描述

我正在使用nvarchar将阿拉伯文本存储在sql服务器中，但是将阿拉伯文本存储为????我不知道该如何解决，有人对此有解决方案吗?有什么区别吗? (开头的N表示unicode)

不，N''我的阿拉伯文本''未做任何更改.它把N ??????而不是在数据库中

您怎么知道您的阿拉伯语文本存储"为"???????"，我相信它是以正确的方式存储的，您的问题是并显示这些阿拉伯字符. SSMS可能无法在网格中向您显示扩展的unicode字符.尝试使用支持阿拉伯字符的字体在Windows文本控件或网页上显示它.

hi i am storing arabic text in sql server using nvarchar, but its storing arabic text as ???? i don''t know how to resolve this , anybody has solution for this?

解决方案

Does N''arabic text'' make any difference? (N at beginning indicates unicode)

no, N''my arabic text'' is not making any change. it put N?????? in database instead

How do you know that your arabic text is "stored" as "???????", I believe it is stored in the proper way, your problem is with display of those arabic characters. SSMS may not be able to show you extended unicode characters in the grid. Try to display it on a windows text control or on a web page with a font that supports arabic characters.

这篇关于sql中存储阿拉伯文本时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！