store arabic in SQL database

by

You need to choose an Arabic collation for your varchar/char columns or use Unicode (nchar/nvarchar)

CREATE TABLE #test
(
col1 VARCHAR(100) COLLATE Latin1_General_100_CI_AI,
col2 VARCHAR(100) COLLATE Arabic_CI_AI_KS_WS,
col3 NVARCHAR(100)
)
INSERT INTO #test VALUES(N'لا أتكلم العربية',N'لا أتكلم العربية',N'لا أتكلم العربية')

Note the N before values in insert statement above. If you do not mention it, system will treat the values as Varchar, not NVarchar.

SELECT * FROM #test

Returns

col1                           col2                           col3
------------------------------ ------------------------------ ------------------------------
?? ????? ???????               لا أتكلم العربية               لا أتكلم العربية

To see a list of Arabic collations use

SELECT name, description 
FROM fn_helpcollations() 
WHERE name LIKE 'Arabic%'

More Related Contents:

  1. Cannot Resolve Collation Conflict
  2. Is it possible to write single query on two table which are not connected to each other?
  3. sql server 2008 management studio not checking the syntax of my query
  4. Split function equivalent in T-SQL?
  5. Is the NOLOCK (Sql Server hint) bad practice?
  6. How to create a table from select query result in SQL Server 2008 [duplicate]
  7. Querying data by joining two tables in two database on different servers
  8. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  9. How to find all connected subgraphs of an undirected graph
  10. Parse comma-separated string to make IN List of strings in the Where clause
  11. SQL query to split column data into rows
  12. OPTION (RECOMPILE) is Always Faster; Why?
  13. Create Trigger to log SQL that affected table?
  14. Rename column SQL Server 2008
  15. Compare DATETIME and DATE ignoring time portion
  16. Split function in SQL Server 2008
  17. Remove numbers from string sql server
  18. How do I edit a table in order to enable CASCADE DELETE?
  19. Using PIVOT in SQL Server 2008
  20. sql group by only rows which are in sequence
  21. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  22. Function in SQL Server 2008 similar to GREATEST in mysql?
  23. SQL Server SELECT LAST N Rows
  24. How to retrieve field names from temporary table (SQL Server 2008)
  25. When using GETDATE() in many places, is it better to use a variable?
  26. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  27. How to execute a stored procedure inside a select query
  28. Using CASE Statement inside IN Clause
  29. Single or multiple databases
  30. SQL Unpivot multiple columns Data

Leave a Comment