collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server 2018-12-13 16-1
         Collations Info
       Home       Concepts       Answers       Reference       Microsoft Connect       Contact 
collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server 
  1. SQL Server Collation for Arabic, Hebrew, English and French
  2. How To Strip Hebrew Accent Marks
  3. Storing Japanese characters in a table
  4. NVARCHAR column as PRIMARY KEY or as UNIQUE column
  5. Why does MS SQL Server return a result for empty string check when Unicode string is not empty
  6. Latin1_General_BIN performance impact when changing the database default collation
  7. What collation to use for Ukraine?
  8. How to disable case sensitivity in SQL Server 2012?
  9. Cannot remove char 0x0000 from NVARCHAR column
  10. DB collation is used for comparison instead of column collation
  11. Automatic Translation when Converting Unicode to non-Unicode / NVARCHAR to VARCHAR
  12. Contained DB Collation error
  13. “String or binary data would be truncated” error copying nvarchar(10) to char(10)
  14. Replace special characters in a column with space
  15. Why not use SQL_Latin1_General_CI_AS for a global system?
  16. Collation conflict … Could not use dbo.sysdac_instances
  17. How do I set a SQL Server Unicode / NVARCHAR string to an emoji or Supplementary Character?
  18. Why are there different Database Collations for different languages?
  19. Does any DBMS have a collation that is both case-sensitive and accent-insensitive?
  20. Can database objects be made case insensitive while keeping strings case sensitive?
  21. Setting and Changing the Server Collation after installation
  22. Error 468 MS SQL Server : Couldn't resolve collation conflict between Arabic_CI_AI and Arabic_CI_AS when enumerating publications
  23. SQL Server: Cannot resolve collation conflict between “Latin1_General_CI_AS” and “[garbage]”
  24. Database collation different from tempdb collation
  25. SQL Server: Collation of the resource database
  26. SSIS Catalogue Inaccessible After Server Collation Change
  27. Change the server Collation
  28. Trigger to change Database collation on creation
  29. Can old collation type impact database performance?
  30. Where can I find exact rules of a collation?
  31. SELECT query: filter unable to distinguish between two different characters
  32. Saving into a VARCHAR(MAX) throwing error in some scenarios
  33. Why is mixing column collations in a single database considered bad?
  34. Encoding issue with SQL Server VARCHAR column retrieved in Python
  35. Can't update “CO2” to “CO₂” in table row
  36. Collate issues with wrong characters
  37. Accent Sensitive Sort
  38. How to create Unicode stored procedure parameter names
  39. SQL Server Bulk Insert properly interprets some Unicode characters but not others?
  40. Character Conversion Issue Importing From CSV File
  41. N'Șc' considered duplicate key of N'C' using Latin1_General_CI_AS collation
  42. inserting a special character into a table
  43. Why isn't Unicode character REPLACEd in some cases?
  44. Why do two identical strings have a different length but the same binary value?
  45. SQL Server 2008R2 database migration to cloud: case-insensitive collation changed to case-sensitive
  46. Why do I get incorrect characters when decoding a Base64 string to NVARCHAR in SQL Server?
  47. Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AI”
  48. Why does using Format vs Right to apply padding cause estimated number of rows to dramatically change?
  49. TSQL Script Execution Through Power shell, Special Characters Rendering Problem
  50. Making collations uniform across multiple SQL Server 2008 databases
  51. Why can't object names start with a number?
  52. (MySQL) Are utf8_bin and utf8_general_cs the same?
  53. What are the rules for using COLLATE?
  54. When `nvarchar/nchar` is going to be used with SQL Server 2019?
  55. VARCHAR memory buffer appears to be breaking in ChineseTaiwan Collation
  56. Trying to check if a string contains a number exclusively
  57. SQL Server 2019 UTF-8 Support Benefits
  58. How to insert a Unicode character verbose into a varchar DB?

  1. Changing the collation of a SQL Server 2012 database
  2. Why does filtering on a range match the wrong case when using a Case Sensitive collation?
  3. Why is Turkish Lira symbol ₺ replaced with ? in SQL server 2008 database
  4. SQL Server returns ??? when column is updated with Thai characters
  5. Unable to return query Thai data
  6. Unicode to Non-unicode conversion
  7. LIKE ignores magic Unicode character
  8. TSQL md5 hash different to C# .NET md5
  9. Replace Unicode characters in T-SQL
  10. SQL Server case insensitive queries
  11. Why did TSQL treat “sofia” as being the same as “sofia”? What string encoding is this?
  12. SQL Server nvarchar N prefix for varchar fields
  13. UTF-8 Support, SQL Server 2012 and the UTF8String UDT
  14. UCS-2 and SQL Server
  15. What are the main performance differences between varchar and nvarchar SQL Server data types?
  16. What is the point of COLLATIONS for nvarchar (Unicode) columns?
  17. SQL Server default character encoding
  18. Double-byte string comparison in C#
  19. Why is SQL Server Big Endian?
  20. Can SQL Server SQL_Latin1_General_CP1_CI_AS be safely converted to Latin1_General_CI_AS?
  21. SQL server filtering CJK punctuation characters
  22. Can sql server give me a warning if I try and insert unicode without the N prefix
  23. What is the difference between NVarchar, Bin collation, Bin2 collation?
  24. Controlling SQL Servers best-fit unicode transformation
  25. How to pass SQL stored procedure NVARCHAR parameter with Hebrew?
  26. Converting accented characters in varchar() to XML causing “illegal XML character”
  27. SQL Server Linked Server to PostgreSQL Turkish Character Issue
  28. Why is '१२३' numeric?
  29. What does 'COLLATE SQL_Latin1_General_CP1_CI_AS' do?
  30. Insert rows with Unicode characters using BCP
  31. SQL Server: set character set (not collation)
  32. SQL Server - defining an XML type column with UTF-8 encoding
  33. Choosing a binary collation that can differentiate between 'ss' and 'ß' for nvarchar column in Sql Server
  34. SQL Server Column names case sensitivity
  35. WHERE equals condition returns mapped Unicode (fullwidth) results
  36. SQL Server 2012- Server collation and database collation
  37. When using Entity Framework with MySQL, Unicode characters are replaced with standard ASCII characters
  38. How to solve “unable to switch the encoding” error when inserting XML into SQL Server
  39. How convert xml string UTF8 to UTF16?
  40. How to add xml encoding <?xml version=“1.0” encoding=“UTF-8”?> to xml Output in SQL Server
  41. Using StringWriter for XML Serialization

Blog Posts
    Moved to "Concepts" page

collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server 2018-12-13 16-1