ASCII versus UNICODE asks different representation questions. Compare a first UTF-8 byte with a code point while preserving the complete input.
SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS
Two ways to check database collation using T-SQL and SSMS in SQL Server 2005, and why DATABASEPROPERTYEX in T-SQL is the one I recommend.
SQL SERVER – 2005 Collation Explanation and Translation – Part 2
Collation Explanation and Translation, part 2: one query on sys.fn_helpcollations() lists all 1011 collations in SQL Server 2005 with a description of each.
Searching Every Stored Procedure for a Word
Searching every stored procedure through sys.sql_modules finds text quickly, but comments, case, dynamic SQL, and other databases need care.
SQL SERVER – Collate – Case Sensitive SQL Query Search
Make a SQL Query Search case sensitive: add COLLATE Latin1_General_CS_AS to the WHERE clause so ‘casesearch’ matches one row instead of all four.
SQL SERVER – 2005 Collation Explanation and Translation
How to read a SQL Server 2005 Collation name like Latin1_General_CI_AS, check which collation you have, and avoid collation conflict errors.







