SQL 2012 Trailing spaces ignored in = boolean
In sql server 2012 when searching for a where a column name = 'C CANTU '
it is returning rows where the column in question = 'C CANTU' This is with
the collation 'SQL_Latin1_General_CP850_BIN2'. In sql 2005 these two
values are not = and these rows are not returned. Is there a setting in
2012 for this? they are nvarchar columns. Same scripts ran against each.
We are just working on trying to upgrade and found inconsistencies in the
final result because of this.
No comments:
Post a Comment