collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server 2024-4-19 23-10
         Collations Info
     Home       Concepts       Answers       Reference       Microsoft Connect       Contact 
collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server
— Answers —


(240 and counting)

DBA.StackExchange
  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. COLLATION and UNION ALL
  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. Which datatype to store XML data in: VARCHAR(MAX) or XML
  21. Collation conflict … Could not use dbo.sysdac_instances
  22. Is there a T-SQL equivalent for punctuation as [0-9] is for numbers and [a-z] is for letters?
  23. How do I set a SQL Server Unicode / NVARCHAR string to an emoji or Supplementary Character?
  24. Why are there different Database Collations for different languages?
  25. Does any DBMS have a collation that is both case-sensitive and accent-insensitive?
  26. Nvarchar to varchar to nvarchar characters conversion
  27. Can database objects be made case insensitive while keeping strings case sensitive?
  28. Setting and Changing the Server Collation after installation
  29. Error 468 MS SQL Server : Couldn't resolve collation conflict between Arabic_CI_AI and Arabic_CI_AS when enumerating publications
  30. When converting dynamic SQL (pivot query) to xml output, why is the first digit of the date converted to unicode?
  31. SQL Server: Cannot resolve collation conflict between “Latin1_General_CI_AS” and “[garbage]”
  32. Database collation different from tempdb collation
  33. SQL Server: Collation of the resource database
  34. SSIS Catalogue Inaccessible After Server Collation Change
  35. Converting varbinary data to varchar in SQLServer leads to unexpected results
  36. Change the server Collation
  37. Can I set Accent insensitive for individual languages?
  38. Trigger to change Database collation on creation
  39. Can old collation type impact database performance?
  40. Where can I find exact rules of a collation?
  41. SELECT query: filter unable to distinguish between two different characters
  42. Saving into a VARCHAR(MAX) throwing error in some scenarios
  43. Why is mixing column collations in a single database considered bad?
  44. Encoding issue with SQL Server VARCHAR column retrieved in Python
  45. How to be sure that a SQL Script is running with ANSI encoding?
  46. Can't update “CO2” to “CO₂” in table row
  47. bcp command Incorrect syntax near '�'. Character is actually: “ä”
  48. Collate issues with wrong characters
  49. Accent Sensitive Sort
  50. How to create Unicode stored procedure parameter names
  51. SQL Server Bulk Insert properly interprets some Unicode characters but not others?
  52. Character Conversion Issue Importing From CSV File
  53. N'Șc' considered duplicate key of N'C' using Latin1_General_CI_AS collation
  54. inserting a special character into a table
  55. Why isn't Unicode character REPLACEd in some cases?
  56. Why do two identical strings have a different length but the same binary value?
  57. What are the current best practices concerning varchar sizing in SQL Server?
  58. SQL Server 2008R2 database migration to cloud: case-insensitive collation changed to case-sensitive
  59. Why do I get incorrect characters when decoding a Base64 string to NVARCHAR in SQL Server?
  60. Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AI”
  61. Why does using Format vs Right to apply padding cause estimated number of rows to dramatically change?
  62. TSQL Script Execution Through Power shell, Special Characters Rendering Problem
  63. Making collations uniform across multiple SQL Server 2008 databases
  64. Why can't object names start with a number?
  65. (MySQL) Are utf8_bin and utf8_general_cs the same?
  66. What are the rules for using COLLATE in a query?
  67. When `nvarchar/nchar` is going to be used with SQL Server 2019?
  68. VARCHAR memory buffer appears to be breaking in ChineseTaiwan Collation
  69. Trying to check if a string contains a number exclusively
  70. SQL Server 2019 UTF-8 Support Benefits
  71. How to insert a Unicode character verbose into a varchar DB?
  72. How to join global temp tables in SQL Server?
  73. SSMS - How to do case-insensitive searches in Object Explorer
  74. Byte ordering for multibyte characters in SQL Server versus Oracle
  75. Implications of changing SQL Server collation
  76. Process to change collation on a database
  77. SQL Server 2016 Collation and Internal table Glitch?
  78. SQL Server 2005/2008 UTF-8 Collation/Charset
  79. Why doesn't MySQL coerce the collation to the column-specified, when comparing to a literal?
  80. What is the SQL Server equivalent of MySQL's utf8mb4 character set?
  81. Sql server 2016 Change only server and without all databases [duplicate]
  82. How to change SQL Server collation
  83. Converting columns from NVARCHAR to VARCHAR
  84. Error: 468 trying to connect to SQL server with SQL Server management studio
  85. MySQL Case Sensitive Join on Varchar
  86. SQL Server Default Collation vs DB with different collation. Potential problems
  87. (MySQL) Change default collation for character set utf8mb4 to utf8mb4_unicode_ci
  88. PostgreSQL: difference between collations 'C' and 'C.UTF-8'
  89. Identify the version of a collation from ICU in Postgres
  90. Why is my UTF-8 document raising UTF-8 encoding errors in Azure Data Lake Analytics?
  91. Importing Chinese characters via SSIS
  92. Is there a MySQL character set and encoding that will allow for both emojis and accents?
  93. How does case-insensitive collation work?
  94. How to bulk convert ISO8859 text in Text columns to UTF8 in nvarchar(max) columns?
  95. Which collation should I use for biblical Hebrew?
  96. Replace function removing Ones / 1 when removing char(185) (superscript 1)
  97. Query to find rows containing ASCII characters in a given range
  98. Change collation on partition column (SQL Server 2017)
  99. Find Table Variables definitions in Stored Procedures
  100. Extended Events Collation resolution error
  101. Why are collations specified at the column level?
  102. Is it possible to determine the default Collation and server version of a database without a full restore?
  103. What is the meaning of “-x-icu” in PostgreSQL's “collates”?
  104. Is there any performance issue with including the “COLLATE” as part of the query as opposed to setting it for the column/table?
  105. Composite index performance with varchar columns
  106. sp_Blitz fails with collation error
  107. PostgreSQL nondeterministic collations are not supported for LIKE
  108. Change collation in easy way
  109. Does MySQL 8 ASCII vs utf8mb4_0900_ai_ci size differ when only using ASCII characters?
  110. Error “the system cannot find the file specified” when opening a large SQL Server file
  111. ERROR: collation “database_default” for encoding “UTF8” does not exist
  112. What is the difference between different utf8mb4 binary collations? (MySQL)
  113. Error converting VARCHAR(MAX) to XML due to “UTF-8” attribute
  114. Are duplicated NVARCHAR values stored as copies in SQL Server?
  115. Case Insensitive ORDER BY clause using COLLATE (PostgreSQL)
  116. Japanese characters in VARCHAR column using Japanese_Unicode_CI_AS
  117. Handle development issues when dealing with different collation for the instance/database setting
  118. How to treat numbers within strings as numbers when sorting (“A3” sorts before “A10”, not after)
  119. to change collation for system database SQL Server 2017
  120. How to create a new column in SELECT CASE when string contains Arabic words?
  121. Msg 6355 “Conversion of one or more characters from XML to target collation impossible” when querying sys.dm_exec_query_plan
  122. Msg 468: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation
  123. What is difference between Arabic_100_CS_AS_KS_WS_SC_UTF8 and Latin1_General_100_CS_AS_KS_WS_SC_UTF8?
  124. What does this statement mean: SELECT ... COLLATE SQL_Latin1_General_CP1_CI_AS AS [-- Logins To Be Created --]
  125. Why does a comparison between 'tr' & 'tR' fail on a SQL Server with Vietnamese_CI_AI collation?
  126. Identify the query causing collation conflict
  127. Is it possible to use OPENROWSET to import fixed width UTF8 encoded files?
  128. Change SQL Server 2019 instance Collation After installation, and new problem
  129. Storing special characters (German, French, Spanish) in SQL Server result in weird strings
  130. SQL Server PATINDEX issue/bug when using different case-sensitive collations
  131. Case Sensitive Collation on a select query in SQL Server
  132. Collation conflict when creating stored procedure
  133. sp_blitz script fails with Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN"

StackOverflow
  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 “ｓｏｆｉａ” 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. Comparing the same character in VARCHAR and NVARCHAR differs between CP1/CP1252 vs. CP850 based on DB collation
  31. How to pass SQL stored procedure NVARCHAR parameter with Hebrew?
  32. Converting accented characters in varchar() to XML causing “illegal XML character”
  33. SQL Server Linked Server to PostgreSQL Turkish Character Issue
  34. Why is '१२३' numeric?
  35. freebcp: “Unicode data is odd byte size for column. Should be even byte size”
  36. What does 'COLLATE SQL_Latin1_General_CP1_CI_AS' do?
  37. Insert rows with Unicode characters using BCP
  38. SQL Server: set character set (not collation)
  39. SQL Server - defining an XML type column with UTF-8 encoding
  40. Choosing a binary collation that can differentiate between 'ss' and 'ß' for nvarchar column in Sql Server
  41. SQL Server Column names case sensitivity
  42. WHERE equals condition returns mapped Unicode (fullwidth) results
  43. Case-sensitive variable / string literal comparison in Stored Procedure
  44. SQL Server 2012- Server collation and database collation
  45. When using Entity Framework with MySQL, Unicode characters are replaced with standard ASCII characters
  46. How to solve “unable to switch the encoding” error when inserting XML into SQL Server
  47. How convert xml string UTF8 to UTF16?
  48. How to add xml encoding <?xml version=“1.0” encoding=“UTF-8”?> to xml Output in SQL Server
  49. Using StringWriter for XML Serialization
  50. SQL server ignore case in a where expression
  51. Special character (Hawaiian 'Okina) leads to weird string behavior
  52. Detect UNICODE characters that are not ASCII in table
  53. Storing Emojis in SQL Tables
  54. MySQL CHAR() Function and UTF8 Output?
  55. MySQL unicode literals
  56. Using Wildcard For Range of Characters In T-SQL
  57. Why does casting a UTF-8 VARCHAR column to XML require converting to NVARCHAR and encoding change?
  58. Unicode REGEX in Sql Server CLR function
  59. SQL Server find accented Latin word using LIKE
  60. SQL Server Unicode queries with SC Collation
  61. Cannot store particular Unicode code points / characters in NVARCHAR fields
  62. NVARCHAR storing characters not supported by UCS-2 encoding on SQL Server
  63. What is regexp_replace equivalent in SQL Server

Blog Posts
    Moved to "Concepts" page





Misc.
  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. nvarchar only allocates 2 bytes per character. len() reports string lengths incorrectly (SQL Server Feedback)
  4. SQL Server 2019 Ukrainian_100_CI_AS_SC_UTF8 with "ьЬ" simmbol ( char 252 and 220 in Ukrainian codepage) (SQL Server Feedback)
  5. SQL Server searching with CJK (Ext A) (SQL Server Feedback)
  6. Undocumented uncompress() function behaves strangely (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. Can we have an emoji datatype! (SQL Server Feedback)
  10. Get Rid of N for Characters and use all Unicode (SQL Server Feedback)
  11. Invalid T-SQL REPLACE function result for CH, Ch using czech/slovak non-binary collations (SQL Server Feedback)
  12. When using UTF-8, varchar(10) should mean 10 characters not 10 bytes (SQL Server Feedback)
  13. String concat expression with scalar function does not produce the same result as the same code execute as a batch. (SQL Server Feedback)

  14. statement_start_offset (MS Documentation Issue)
  15. Case insensitive wildacard range (MS Documentation Issue)
  16. Getting different answer while using PARSENAME (MS Documentation Issue)
  17. Specify a default collation (MS Documentation Issue)
  18. Is the default server-level collation specific to the locale settings on that machine? (MS Documentation Issue)

  19. Convert Unicode code point to corresponding character in Excel spreadsheet (SuperUser.StackExchange)
  20. Are there any diacritics not on the top or bottom of a letter? (Linguistics.StackExchange)
  21. Why does Unicode have big or little endian but UTF-8 doesn't? (SuperUser.StackExchange)


Copyright © 2017-2024 Solomon Rutzky. All rights reserved.
collation, encoding, code page, locale, sorting, comparison, LCID, T-SQL, TSQL, SQL Server 2024-4-19 23-10