[Answered ]-Django queryset not escaping text in a where…in query

Seems to be an odd behavior when Django replaces contents to apply the query filter.

Maybe it worths trying this:

locations = [u’\’San Francisco\”, u’\’New York\”]

Unfortunately, that’s a known limitation of the Django queryset query attribute. The Django devs only provide that for debugging, and have refused to modify it to reflect the actual database backend, so it won’t properly escape certain datatypes correctly.