django python collation error

Question

What is the reason for the following error? when i try to filter with:

if MyObject.objects.filter(location = aDictionary['address']):

where location is defined as:

location = models.CharField(max_length=100, blank=True, default='')

I get the following error when aDictionary['address'] contains a string with a non-alphanumeric character (for example Kīhei):

  File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaul
terrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1267, "Illegal mix of collations (latin1_sw
edish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='")

a paid nerd · Accepted Answer · 2011-08-17 04:49:17Z

7

Alter the database in MySQL like so:

ALTER TABLE foo CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

When creating a new database, remember to create with the right collate settings:

CREATE DATABASE foo CHARACTER SET utf8 COLLATE utf8_general_ci;

More discussion here.

edited Aug 17, 2011 at 4:49

answered Aug 16, 2011 at 18:56

a paid nerd

31.7k31 gold badges141 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jordan Over a year ago

So, you recommend dropping the database, including all of its tables and possibly production data, in order to change collation? How about changing that to ALTER statements instead?

a paid nerd Over a year ago

I swear that when I encountered this problem all of the docs said I needed to DROP and CREATE. So I researched, and you're right. Post edited.

Jamison Dance · Accepted Answer · 2011-08-16 18:53:41Z

1

Python is using Unicode strings, and your database is not. Change your database collation to use utf8 and you should be fine.

answered Aug 16, 2011 at 18:53

Jamison Dance

20.3k25 gold badges102 silver badges100 bronze badges

Collectives™ on Stack Overflow

django python collation error

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related