Hi,

Getting started.

I've got a MySQL database running on Windows (MySQL on Windows is not
case sensitive)

I create a model called People which has a Class called Person.

I sync the database and it creates a table "people_person"

If I immediately run syncdb again, it errors out with:

Creating table People_person
Traceback (most recent call last):
  File "manage.py", line 11, in <module>
.
.
.
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1050, "Table 'people_person'
already exists
")


Notice that it doesn't think that People_person exists because it is
using a case sensitive search in Python and then it attempts to create
the table which FAILS in the case insensitive Windows MySQL.

I'm looking at a book that advises setting uses_case_insensitive_name
= True in the django/db/backends/__init__py file....but this doesn't
seem to work.

This seems like a bug to me in the MySQL implementation. Can someone
suggest the best way to work around this problem or to set the db case
insensitivity....

Thanks
Tom
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to