A bracket range sounds simple until the collation decides what sits between a and f. Test it once so a bad code never reaches your table.
Rows That Look Identical but Are Not: Finding Hidden Characters
Expose hidden characters with DATALENGTH and UNICODE, clean known whitespace safely, and add a constraint to prevent recurrence.
Sorting Correctly: Collation and ORDER BY
Collation and ORDER BY decide case, accent, and text-number order; choose rules explicitly when one report needs different sorting.
Text Equality: Trailing Spaces Can Compare as Equal
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.







