Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'

[Ken Allen]

Does this also explain why, when using mono under MacOS X, I get the error "System.NotSupportedException: Encoding name `latin1' not supported" from the following lines of code?

string database = "Persist Security Info=False;Server=localhost;Database=MyTestDB;User ID=Ken;Password=Allen";

_Connection = new MySqlConnection(database);

_Connection.Open();