utf8_bin or latin1_swedish_ci?

Discussion in 'MySQL' started by cre8ive, Nov 15, 2007.

  1. #1
    Does MySQL 4.1.x set the collation of a field to latin1_swedish_ci when it imports data from 3.23? And also it sets the collation of a table to latin1_swedish_ci?

    I seem to remember reading that it’s always ideal to set the collation to utf8_bin unless there is a good reason to select a different collation. Is this true …? Which is better, utf8_bin or latin1_swedish_ci?
     
    cre8ive, Nov 15, 2007 IP