You can change to collation of your MySQL tables by table and by field. If you do it by table, all new fields are of that collation. If you already have fields of a collation, you will have to change all of them.
I used PHPMyAdmin to do it as the interface is nice and simple. You probably will also be able to do it with the MySQL Admin tool that they have as a download. Corey On Sep 5, 2006, at 10:18 AM, PythonistL wrote: > > Thank you for the reply > I still use Django 0.91 and I could not find > django/db/backends/mysql/base.py > > I found only C:\Python23\Lib\site-packages\django\core\base.py > and C:\Python23\Lib\site-packages\django\core\db\mysql.py > > Which file should I change with > if self.connection.get_server_info() >= '4.1': > cursor.execute("SET NAMES utf8") ? > > Scater, > the erorr says: > Exception Value: (1267, "Illegal mix of collations > (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for > operation '='") > Exception Location: > C:\PYTHON23\lib\site-packages\MySQLdb\connections.py in > defaulterrorhandler, line 32 > > The exception Value is from this command: > gallerys.get_list(Title__exact=new_data['Title']) > So, how can I find out what has (latin1_swedish_ci,COERCIBLE) > collation? > Title field has that or new_data['Title'] has the > (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 -~----------~----~----~----~------~----~------~--~---