-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Nigel Frankcom wrote: > I'm not sure what you've done there, I didn't realise it was > possible to mix collation types in the same table. Have you checked > that all tables are the same type? MyISAM or Inno? If they are all > the same, I'd be inclined to pull it down, rebuild from the SA > supplied SQL and retrain. >
The tables are all MyISAM... But the collation is latin1_swedish_ci for some reason, WHich seems strange to me. What collation do others have? And what should it be? (I'm assuming the problem is SA using utf8 & the database using latin1_swedish_ci). I'm looking now to see if it's possible to change the collation on the fly. > Did you merge 2 databases at any point? > > Nigel > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFE2HDE/3QXwQQkZYwRAl+TAJ92L9d4yvm48M/4fCj/6HlOwJIdfACgvwxz OSh1p7YKzNR/GBNLTsQsSXU= =nTNc -----END PGP SIGNATURE-----
