Thanks Dimitry, > If you want space to take part in comparison, use char fields instead of > varchar. See:http://dev.mysql.com/doc/refman/5.0/en/char.html
The below quote from the reference link you sent would seem to indicate that trailing spaces *do not* take part in the comparison in char fields either? "All MySQL collations are of type PADSPACE. This means that all CHAR and VARCHAR values in MySQL are compared without regard to any trailing spaces." Regardless, one would surely not wish to force a specific storage type from within Django. Steven. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.