collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server 2019-9-19 23-59
         Collations Info
     Home       Concepts       Answers       Reference       Microsoft Connect       Contact 
collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server 

(167 and counting)

  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?
  10. Cannot remove char 0x0000 from NVARCHAR column
  11. DB collation is used for comparison instead of column collation
  12. Automatic Translation when Converting Unicode to non-Unicode / NVARCHAR to VARCHAR
  13. How to find values with multiple consecutive upper case characters
  14. Contained DB Collation error
  15. “String or binary data would be truncated” error copying nvarchar(10) to char(10)
  16. Is there a collation to sort the following strings in the following order 1,2,3,6,10,10A,10B,11?
  17. Replace special characters in a column with space
  18. ORDER BY and comparison of mixed strings of letters and numbers
  19. Why not use SQL_Latin1_General_CI_AS for a global system?
  20. Collation conflict … Could not use dbo.sysdac_instances
  21. Is there a T-SQL equivalent for punctuation as [0-9] is for numbers and [a-z] is for letters?
  22. How do I set a SQL Server Unicode / NVARCHAR string to an emoji or Supplementary Character?
  23. Why are there different Database Collations for different languages?
  24. Does any DBMS have a collation that is both case-sensitive and accent-insensitive?
  25. Nvarchar to varchar to nvarchar characters conversion
  26. Can database objects be made case insensitive while keeping strings case sensitive?
  27. Setting and Changing the Server Collation after installation
  28. Error 468 MS SQL Server : Couldn't resolve collation conflict between Arabic_CI_AI and Arabic_CI_AS when enumerating publications
  29. When converting dynamic SQL (pivot query) to xml output, why is the first digit of the date converted to unicode?
  30. SQL Server: Cannot resolve collation conflict between “Latin1_General_CI_AS” and “[garbage]”
  31. Database collation different from tempdb collation
  32. SQL Server: Collation of the resource database
  33. SSIS Catalogue Inaccessible After Server Collation Change
  34. Converting varbinary data to varchar in SQLServer leads to unexpected results
  35. Change the server Collation
  36. Can I set Accent insensitive for individual languages?
  37. Trigger to change Database collation on creation
  38. Can old collation type impact database performance?
  39. Where can I find exact rules of a collation?
  40. SELECT query: filter unable to distinguish between two different characters
  41. Saving into a VARCHAR(MAX) throwing error in some scenarios
  42. Why is mixing column collations in a single database considered bad?
  43. Encoding issue with SQL Server VARCHAR column retrieved in Python
  44. How to be sure that a SQL Script is running with ANSI encoding?
  45. Can't update “CO2” to “CO₂” in table row
  46. bcp command Incorrect syntax near '�'. Character is actually: “ä”
  47. Collate issues with wrong characters
  48. Accent Sensitive Sort
  49. How to create Unicode stored procedure parameter names
  50. SQL Server Bulk Insert properly interprets some Unicode characters but not others?
  51. Character Conversion Issue Importing From CSV File
  52. N'Șc' considered duplicate key of N'C' using Latin1_General_CI_AS collation
  53. inserting a special character into a table
  54. Why isn't Unicode character REPLACEd in some cases?
  55. Why do two identical strings have a different length but the same binary value?
  56. What are the current best practices concerning varchar sizing in SQL Server?
  57. SQL Server 2008R2 database migration to cloud: case-insensitive collation changed to case-sensitive
  58. Why do I get incorrect characters when decoding a Base64 string to NVARCHAR in SQL Server?
  59. Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AI”
  60. Why does using Format vs Right to apply padding cause estimated number of rows to dramatically change?
  61. TSQL Script Execution Through Power shell, Special Characters Rendering Problem
  62. Making collations uniform across multiple SQL Server 2008 databases
  63. Why can't object names start with a number?
  64. (MySQL) Are utf8_bin and utf8_general_cs the same?
  65. What are the rules for using COLLATE?
  66. When `nvarchar/nchar` is going to be used with SQL Server 2019?
  67. VARCHAR memory buffer appears to be breaking in ChineseTaiwan Collation
  68. Trying to check if a string contains a number exclusively
  69. SQL Server 2019 UTF-8 Support Benefits
  70. How to insert a Unicode character verbose into a varchar DB?
  71. How to join global temp tables in SQL Server?
  72. SSMS - How to do case-insensitive searches in Object Explorer
  73. Byte ordering for multibyte characters in SQL Server versus Oracle
  74. Implications of changing SQL Server collation
  75. Process to change collation on a database
  76. SQL Server 2016 Collation and Internal table Glitch?
  77. SQL Server 2005/2008 UTF-8 Collation/Charset
  78. Why doesn't MySQL coerce the collation to the column-specified, when comparing to a literal?
  79. What is the SQL Server equivalent of MySQL's utf8mb4 character set?
  80. Sql server 2016 Change only server and without all databases [duplicate]
  81. How to change SQL Server collation
  82. Converting columns from NVARCHAR to VARCHAR
  83. Error: 468 trying to connect to SQL server with SQL Server management studio
  84. MySQL Case Sensitive Join on Varchar
  85. SQL Server Default Collation vs DB with different collation. Potential problems
  86. (MySQL) Change default collation for character set utf8mb4 to utf8mb4_unicode_ci
  87. PostgreSQL: difference between collations 'C' and 'C.UTF-8'
  88. Identify the version of a collation from ICU in Postgres

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

Blog Posts
    Moved to "Concepts" page

  1. JRASERVER-65634: Customer getting collation error even though collations is correct. However deeper investigations reveals that the issue is with temp tables. Since they are using a shared database server it's collation is not the same as the Database. (JIRA Server (including JIRA Core))

  2. #111 Unicode compression scheme is invalid (at least when using Access 2000 DB) (Jackcess)

  3. Undocumented uncompress() function behaves strangely (SQL Server Feedback)
  4. nvarchar only allocates 2 bytes per character. len() reports string lengths incorrectly (SQL Server Feedback)
  5. SQL Server 2019 Ukrainian_100_CI_AS_SC_UTF8 with "ьЬ" simmbol ( char 252 and 220 in Ukrainian codepage) (SQL Server Feedback)
  6. SQL Server searching with CJK (Ext A) (SQL Server Feedback)
  7. Escaped, open square bracket '[[' not decoded - Microsoft.SqlServer.TransactSql.ScriptDom.Identifier.DecodeIdentifier() (SQL Server Feedback)
  8. CHARINDEX function wrong with COLLATE Vietnamese_CI_AS (SQL Server Feedback)

  9. statement_start_offset (MS Documentation Issue)
  10. Case insensitive wildacard range (MS Documentation Issue)
  11. Getting different answer while using PARSENAME (MS Documentation Issue)

  12. Convert Unicode code point to corresponding character in Excel spreadsheet (SuperUser.StackExchange)
collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server 2019-9-19 23-59