SQL server 2008 arabic data

Question

0.00/5 (No votes)

See more:

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,,

Posted 27-May-12 7:40am

Afnan_

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

madhusudhan.k · Answer 1 · 2012-05-27T20:52:00

Solution 1

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).

Posted 27-May-12 20:52pm

madhusudhan.k

Comments

Afnan_ 28-May-12 14:31pm

A friend has told that the issue was in the saving itself.The data was sent to the database as ???? and the cause of that was because I'm using Ajax in my pages
Bt II really don't know how to solve this issue, because I need the Ajax in my pages.

madhusudhan.k 29-May-12 2:22am

I think the problem is not with the ajax, but Iam not sure.
But this is sure that, while you pass the data from C# to procedure with 'N' Prefix (N'xyz') then it will work, but the table field datatype should be nvarchar.

hima8002 · Answer 2 · 2013-07-09T22:45:00

Solution 2

try this:

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

Posted 9-Jul-13 22:45pm

hima8002