First thing that comes to mind is Unicode conversion problems. That data must be stored as nvarchar() or nchar(). If any table application, column, temp table column, or variable touched that data along its path to the table was char() and not nchar(), then it would get mangled.