Wednesday, October 15, 2008

Question Marks Problem, Arabic Data with ASP and SQL Server

Sometimes we face this problem with saving Arabic data, the data gets inserted in the database as “?????????????” here I’ll explain our steps if we faced this problem:
1-make sure that you use stored procedure as you can in you solution.
2-make sure that your aspx files saved as Unicode utf-8
clip_image003
3-Make sure that your database Collation is Arabic_CI_AS
clip_image005
Note: to Alter your database collation use this statement
alter database DB-NAME collate Arabic_CI_AS

0 comments:

Post a Comment