Here's the output from the 'portfolio_workcategory' table create:
-- Table "portfolio_workcategory" DDL
CREATE TABLE `portfolio_workcategory` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(30) collate utf8_bin NOT NULL,
`position` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8
COLLATE=utf8_bin;
I'm assuming the "COLLATE=utf8_bin" is what's causing the problem?
Thanks,
Brandon
On Apr 9, 3:14 pm, "Karen Tracey" <[EMAIL PROTECTED]> wrote:
> On Wed, Apr 9, 2008 at 3:31 PM, Brandon Taylor <[EMAIL PROTECTED]>
> wrote:
>
>
>
>
>
> > Hi Karen,
>
> > Here's an example of one of the models in question:
>
> > class WorkCategory(models.Model):
> > title = models.CharField(max_length = 30)
> > position = models.PositiveSmallIntegerField()
>
> > def __unicode__(self):
> > return self.title
>
> > class Admin:
> > ordering = ('position',)
> > search_fields = ('title')
>
> > class Meta:
> > verbose_name_plural = 'Work Categories'
>
> > When I created the database, I specified the default character set as
> > unicode, but other than that, I haven't made any changes to the
> > database. I actually haven't even touched it directly, only through
> > the Python code in Django.
>
> Does your database server have a default binary collation defined? From a
> mysql command prompt, enter "use your_database_name" then "show variables
> like 'coll%;' to see the default collations for the connection, database,
> and server. For good measure you can look at the output of "show create
> table your_table_name;" to see if there are binary collations associated
> with the table's columns.
>
> If none of those show that you've somehow got a binary collation associated
> with this table, then I'm baffled.
>
> Karen
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
