>>Dear Experts,
>>
>>I am trying insert into SQL server2005, using below code in Arabic fonts.
>>
>>cAra_Name = thisform.Arabic_Name.Value
>>
>>cSql = "Insert Into AraDB.dbo.Ara_Table (ID,Ara_Name) Values (?nID,?cAra_Name)"
>>
>>It storing in like as ???????????? characters in the table . And also displaying like unknown characters.
>>
>>How to solve this issue.
>>thanks in advance.
>>
>>Regards
>>Abdulla
>>
>>
>
>Check this blog post
>
http://blogs.lessthandot.com/index.php/datamgmt/datadesign/displaying-and-saving-unicode-data/I think this's not a unicode letter problem. Arabic letters are in asci 255 table.
Abdullah,
Check;
-Your non unicode applications language for arabic from control panel->regional settings->advanced
-Your VFP and SQL Server's codepages.
make config.fpw file as:
codepage=auto
also you may do;
collate=arabic
You have to choose your SQL SERVER database's codepage when creating it.