SQL: Pattern Matching Issues with Unicode Datatypes

There is another little twist with regard to trailing spaces which waits to trip you up in Microsoft T-SQL.

1. When defining columns to store character data in tables we can either store as ASCII characters or Unicode characters.

2. When Unicode data (nchar or nvarchar data types) are used with LIKE, trailing blanks are significant and you will need to allow for them.

Read More Here: SQL Pattern Matching

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.