Join column with different collation issue
Posted
by George2
on Stack Overflow
See other posts from Stack Overflow
or by George2
Published on 2009-05-10T13:17:12Z
Indexed on
2010/03/11
19:04 UTC
Read the original article
Hit count: 446
Hello everyone,
I am using SQL Server 2005. I have two tables, and they are using different collations. It is not allowed to concatenate columns from tables with different collations, for example the following SQL is not allowed,
select table1column1 + table2column2 from ...
My question is, why concatenation of two columns from different collations is not allowed from database engine design perspective? I do not know why collation will impact results, the result is just concatenating strings -- should be simple enough and not dependent on collation...
thanks in advance, George
© Stack Overflow or respective owner