monkeybiz12345
asked on
Database collation and column collation different - Does it matter?
Greetings!
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER