Loading

Displaying sql data with question marks for arabic in asp

Sayareddy G

Hi,

In SQL server we have Arabic data. I am trying to display this in asp page but it is displaying as question marks instead arabic data. When I try the same query in SQL server it is displaying correct. And static data in asp page is displaying properly. Only the data which is getting from SQL server is displaying in question marks.

Any help would be greatly appreciated.

Regards,

Saya

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

mohammed alsailamy11y ago
your problem at the Sql server :

RIGHT CLICK ON DATABASE Name > PROPERTIES >Select OPTIONES Tab from left > change Collaction : Arabic_CI_ AS > done
0
Sayareddy G11y ago
Dear Kumar,

Thank you for your reply.
This is I tried. Still the issue is remain the same. Just to inform you that the data which is retrieving from SQL database only getting this issue. Static arabic data which is available in asp page is displaying properly.

Thanks.
0
Shubham Kumar11y ago
Change the ContentEncoding to windows-1256 or utf-8
0