Is there one database collation that is better than another? This is something that I am not to familiar with.

I didn't set up the original install of 1.3 that we are currently running.

The database collation set is latin1_swedish_ci.

I am going to be doing an upgrade to 1.5. I am wondering if I need to have the collation for the new database the same of does it really matter?