T-SQL Check if String contains unicode character(s)

T-SQL - Checking for Unicode characters

Here is a code in T-SQL which will check if a string contains UNICODE characters:

Lets create a table variable:


declare @temp table (Name varchar(100), Address1 nvarchar(200))


Now we will insert two records, one of which contains ascii and one non-ascii character.



Posts By Month