I needed to check Unicode characters under a column in SQL Server. I could check using the below script
SELECT *
FROM ITEM
WHERE cast(cast([DESC] as varchar(max)) as nvarchar(max)) <> [DESC]
FROM ITEM
WHERE cast(cast([DESC] as varchar(max)) as nvarchar(max)) <> [DESC]
No comments:
Post a Comment