Collation can be defined at column level in MS SQL Server. An annoying error that comes up when using two columns that have different collations defined.