how to insert unicode text to SQL Server from query window

by

The following should work, N indicates a “Unicode constant string” in MSSQL:

INSERT INTO tForeignLanguage ([Name]) VALUES (N'Араб')

More Related Contents:

  1. How do I see what character set a MySQL database / table / column is?
  2. Difference between BYTE and CHAR in column datatypes
  3. MySQL: Get character-set of database or table or column?
  4. Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’
  5. How to create id with AUTO_INCREMENT on Oracle?
  6. Conversion failed when converting date and/or time from character string while inserting datetime
  7. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  8. Difference between EXISTS and IN in SQL?
  9. How should I pass a table name into a stored proc?
  10. Get the last inserted row ID (with SQL statement) [duplicate]
  11. Is it possible to make a recursive SQL query?
  12. Fetch the rows which have the Max value for a column for each distinct value of another column
  13. Run all SQL files in a directory
  14. Sql Server deterministic user-defined function
  15. Oracle: loading a large xml file?
  16. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  17. How to get the numeric part from a string using T-SQL?
  18. MySQL: How to copy rows, but change a few fields?
  19. How to renumber primary index
  20. Query that ignore the spaces
  21. How to enable Ad Hoc Distributed Queries
  22. Sleep function in ORACLE
  23. Postgres function returning table not returning data in columns
  24. SQL Server SELECT LAST N Rows
  25. update columns values with column of another table based on condition [duplicate]
  26. how to select even records from a table in oracle?
  27. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  28. Oracle DB: How can I write query ignoring case?
  29. Perform JOIN query in google cloud firestore
  30. ALTER TABLE without locking the table?

Leave a Comment