Determine if a SQL table column has any unicode
04-Jun-1313 Leave a comment
Trying to reduce database-table-size by changing nvarchar to varchar where there is no unicode
SELECT TheColumn
FROM MyTable
WHERE TheColumn<>CONVERT(nvarchar(100),CONVERT(varchar(100),TheColumn))