Arabic Character Display Error

Hi,
The link below shows a lot of solutions for Arabic support in SQL Server 2005.
I think the same applies to SQL Server 2008 because I couldn't find anything updated.
Scroll through this page and you will see several methods to get your records back from SQL Server as Arabic.
http://technet.microsoft.com/en-us/library/cc295829(SQL.90).aspx
Salute,
Mark



Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

 

Hello
I'm storing character in Arabic language inside database.
If you see the first record (Note) at the link below , the character appear like this "???????"

Although its stored correctly in my database (in Employees Table), and the encoding ASP Page is correct and Collation Database is Arabic?
http://raptechnol1.eweb101.discountasp.net/tech/temp.asp

Please advice.

 

Hi,
What Database type and column type are you using?
Salute,
Mark




Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

 

hi
I'm using SQL 2008 with collation Arabic CI