Database collation and column collation different - Does it matter?
Posted on 2014-01-15
I have several SQL databases on my system. At the database level, the collation for all of them is set to LATIN1_GENERAL_BIN. On some of them, the collation of some columns is set to LATIN1_GENERAL_100_BIN.
Practically speaking, does this matter?
For example, I will need to combine the data in 2 of these tables that have different column level collations by adding records that only exist in Table1 to Table2. I did a small test and I was able to add records.
Thanks, in advance, for your help.