Text equality can match different stored strings. Check byte length and complete representation when exact identity belongs to the contract.
Accent-Insensitive Searches: Finding Jose and José Together
Build accent-insensitive searches with explicit collations, compare case rules, and index a computed search column for consistent lookup.
REPLACE With COLLATE: Choose Case Matching Explicitly
REPLACE with COLLATE controls which substrings match. Preview case-dependent results before applying a text replacement policy.
Multi-Language Text: A Table Design for Translations
Multi-language text separates product identity from translated names. This test setup checks requested, fallback, and base names, Unicode text, duplicate tags, missing rows, and a precise blank policy.
Migrating From MySQL to SQL Server: The Gotchas
Migrating from MySQL to SQL Server needs identity, collation, paging, and date rules, with SSMA assessing and converting the bulk of the work.
SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script
Brian Cidern’s extension script for consolidating collations across a database, a big help when you face the annoying cannot resolve collation error.
NULLIF Text: Collation Decides Whether Values Match
NULLIF text comparisons can remove a matching value. Select the matching rule explicitly and preserve the first expression’s return contract.