1

When using arabic language, data is stored in database with ? (question mark) sign instead of real arabic characters in SQL server. Suggest me solution if anybody have idea.

Pranay Rana
  • 175,020
  • 35
  • 237
  • 263
Nijesh patel
  • 11
  • 2
  • 1
    What is the default DB collation? What type is the column that is displaying the problem? You need to give more detail if you want a meaningful answer. – Oded May 17 '10 at 06:55

1 Answers1

0

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.

Oded
  • 489,969
  • 99
  • 883
  • 1,009
  • I am converting data to nvarchar before storing it to DB. The data type of field where data is being stored is xml? Is it create problem ? – Nijesh patel May 17 '10 at 07:01
  • @Nijesh patel - Are you storing regular text in a XML field? It is not XML? – Oded May 17 '10 at 07:08