I have a table having a column by name Description with NVARCHAR datatype. It may contain Unicode characters. I needed to find in which row it exists. I used this query which returns the row containing Unicode characters.
MS Access
To find Unicode characters in MS Access, I could not found a better way. so the best way is to import the access data into SQL Server and follow above method.
SELECT * FROM Mytable WHERE [Description] <> CAST([Description] as VARCHAR(1000))
This query works as well
SELECT * FROM [ITEM]
WHERE [DESC] LIKE N'%[^ -~]%' collate Latin1_General_BIN
WHERE [DESC] LIKE N'%[^ -~]%' collate Latin1_General_BIN
MS Access
To find Unicode characters in MS Access, I could not found a better way. so the best way is to import the access data into SQL Server and follow above method.
