How to insert Arabic characters into SQL database?

by

For the field to be able to store unicode characters, you have to use the type nvarchar (or other similar like ntext, nchar).

To insert the unicode characters in the database you have to send the text as unicode by using a parameter type like nvarchar / SqlDbType.NVarChar.

(For completeness: if you are creating SQL dynamically (against common advice), you put an N before a string literal to make it unicode. For example: insert into table (name) values (N'Pavan').)

More Related Contents:

  1. Inserting multiple rows in a single SQL query? [duplicate]
  2. How can I INSERT data into two tables simultaneously in SQL Server?
  3. Convert text to system date format [duplicate]
  4. How to get a particular preceding value of a column in SQL [closed]
  5. SQL where clause odd behavior [closed]
  6. How do I escape a single quote in SQL Server?
  7. Simple way to transpose columns and rows in SQL?
  8. Only inserting a row if it’s not already there
  9. Unpivot with column name
  10. Selecting data from two different servers in SQL Server
  11. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  12. SQL JOIN vs IN performance?
  13. Most efficient way in SQL Server to get date from date+time?
  14. Convert varchar into datetime in SQL Server
  15. TSQL Pivot without aggregate function
  16. How to generate a range of dates in SQL Server
  17. SQL RANK() versus ROW_NUMBER()
  18. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  19. How do I delete from multiple tables using INNER JOIN in SQL server
  20. Check if a row exists, otherwise insert
  21. SQL : BETWEEN vs =
  22. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  23. How do I perform a GROUP BY on an aliased column in SQL Server?
  24. How do I make a composite key with SQL Server Management Studio?
  25. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  26. SQL speed up performance of insert?
  27. TransactSQL to run another TransactSQL script
  28. Getting Dates between a range of dates
  29. Why is RAND() not producing random numbers?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment