Arabic charcters storesd in my sql database as "???????"

Hi,
Here are some resources that should help:

Time Zone Codes
http://msdn2.microsoft.com/en-us/library/ms145276.aspx

Numeric Data Formats
http://msdn2.microsoft.com/en-us/library/ms141729.aspx

Complex Script Support
http://msdn2.microsoft.com/en-us/library/ms142794.aspx

CAST and CONVERT
http://msdn2.microsoft.com/en-us/library/ms187928.aspx

Shalom,
Mark

 

Arabic charcters storesd in my sql database as "???????"
>
> iam useing SQl sever 2000

i try to use

COLLATE SQL_Latin1_General_CP1256_CI_AS

and

COLLATE Arabic_CI_AS

both not working please help

 

Use the nvarchar data type to support unicode characters. You probably have to reinsert the data.

Aristotle

DiscountASP.NET
www.DiscountASP.NET

 

That is a good tip.
Always use nvarchar when the sizes ofyour column datais probably going to vary.
Salute,
Mark

 

i used varchar as data type


i think my problem with database COLLATE i tried every COLLATE spported by sql 2000 for arabic but non of them worked with me i still have ?????? in my data base


mybe there is probelm with opreating system fonts or some thing i do not know


please help

 

Thereare a lot of articles dedicated to this on MSDN.
Please search for now and I'll keep looking into this for you.
Shalom,
Mark

 

thanks it works

 

when i tried to insert arabic data from website arabic character still inserted like ???????

why?

i tied to use
charset=windows-1256"

and
utf-8

no use please help