SQL server globalization
When using arabic language, data is stored in database with ? (question mark开发者_StackOverflow) sign instead of real arabic characters in SQL server. Suggest me solution if anybody have idea.
There are several possibilities here:
- Your language of choice is not encoding the text properly. Make sure you use unicode strings.
- You are transferring the data incorrectly. Are you using the correct SQL types? NVarChar instead of VarChar, NChar instead of Char for your stored procedure parameters.
- You are saving the data incorrectly. Again you should be using NVarChar fields instead of VarChar, NChar instead of Char etc...
You should be using unicode character strings at all places. See the list of SQL Server data types.
精彩评论