Hi,
I've noticed that my application changes case sensitivity in queries
depending on whether it is using MySQL or sqlite as the database
backend
The simplest test case is as follows:
My database contains a user record, in which the username is = "jon"
My urls.py is simply as follows:
(r'^/?(?P<person>\w+)/$', 'abnew.planetx.views.user'),
My corresponding view code to retrieve this user is like this:
def user(request, person):
# Let the logger know where we are.
logging.info("Rendering person " + person)
user = User.objects.get(username=person)
Now, if I point my browser at localhost:8000/jon, or
localhost:8000/Jon when using MySQL, the query works correctly.
However, when using sqlite the second query will not work (as the
first character is upper case, and hence different from what is in the
database).
If there a recommended way to deal with this? I want to avoid forcing
a certain scheme on the users (i.e., they can type the name in all
lowercase, uppercase or mixed, it doesn't matter).
Thanks,
--Jon
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
