SQL server 2008阿拉伯语数据 [英] SQL server 2008 arabic data

问题描述

请检查以下问题：



托管阿拉伯语网站后（如阿拉伯语一样），文本显示正常。但是当您从网站插入或更新数据时，然后您查看它，文本显示为????我已经做了很多研究并尝试了所有建议的解决方案，但即便如此，文本仍然显示为?????，请检查以下建议点我尝试但没有得到结果：



1.页面编码 UTF-8

2.将所有 varcahr 改为表和存储过程中的nvarchar 。

3.将web.config文件中的全球化标记设置为：

< globalization requestencoding =utf-8 responseencoding =utf-8fileencoding =utf-8uiculture =ar-JOculture =ar-JO>

4.将元标记中的字符集设置为 UTF-8 。 EX：< meta http-equiv =Content-Typecontent =text / html; charset = utf-8/>

5.设置整理 sql表中的值为SQL_Latin1_General_CP1256_CI_AS



所有这些试用后我真的希望有人能解决我的问题。



提前谢谢你，

Kindly check the following problem:

After hosting an Arabic site(as in written in Arabic), the text appears okay. But when you insert or updata data from the site then afterwards you view it, the text appear as "????" I have did a lot of research and tried all the suggested solutions but even so the text still appears as "?????", check the below suggested points that I have tried but got no results from:

1.Page encoding is UTF-8
2.Changed all the varcahr to nvarchar in tables and stored procedures.
3.Set the globalization tag in the web.config file to :
<globalization requestencoding="utf-8" responseencoding="utf-8" fileencoding="utf-8" uiculture="ar-JO" culture="ar-JO">
4.Set the charset in the meta tag to "utf-8". EX:<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
5.Set the collation value in the sql table to SQL_Latin1_General_CP1256_CI_AS

So after all these tryouts I really do hope that someone has a solution to my problem.

Thank you in advance,,

推荐答案

我想你传递给表格的数据是这个格式化的'????'。

并确保你传递给程序的文本框值应该在格式N'مادو'中（使用N前缀）。

Hi,

I think the data which you are passing to table is in this formate '????'.
And make sure that the textbox value what you pass to the procedure should be in the formate N'مادو' (with N Prefix).

试试这个：



alter table tbl_Categories

alter column CatName varchar （100）COLLATE Arabic_CI_AI

try this:

alter table tbl_Categories
alter column CatName varchar(100) COLLATE Arabic_CI_AI

这篇关于SQL server 2008阿拉伯语数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！