Believe it or not, latin1_swedish_ci is a default collation for MySQL. I recommend using PHPMyAdmin. It is the easiest way to see the collations and change the collations. (but you have to use PHP :( )
You can use the MySQL Administrator GUI but it is a pain as you have to do a lot more clicking to get into the tables and see the collations. I don't know how to do it from the command line, as I have always used PHPMyAdmin to do it. Wish I could be of more help, Corey On Sep 6, 2006, at 4:16 AM, PythonistL wrote: > > Corey, > Thank you for your reply. > The exception Value > > (1267, "Illegal mix of collations (utf8_czech_ci,IMPLICIT) and > (latin1_swedish_ci,COERCIBLE) for operation '='") > > > is from this command: > gallerys.get_list(Title__exact=new_data['Title']) > So, I would guess that Title field or new_data['Title'] has > (latin1_swedish_ci,COERCIBLE) collation. > But how can I find out which one is of (latin1_swedish_ci,COERCIBLE) > collation? > > Thank you for the reply > L. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---