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.
monkeybiz12345Asked:
Who is Participating?
 
Dan CraciunIT ConsultantCommented:
In your case you're using the same character set (Latin1) and different collations.

Since the collation is a set of rules for comparing characters in a character set, it does not matter when importing data from a field with the same charset.

HTH,
Dan
0
 
monkeybiz12345Author Commented:
Thanks Dan! Exactly what I wanted to know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.