#18661: special characters like "é" or "è" in sqlite3 file path raise a
"sqlite3.OperationalError: unable to open database file"
-------------------------------------+-------------------------------------
Reporter: oncleben31 | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 1.4
(models, ORM) | Resolution:
Severity: Normal | Triage Stage:
Keywords: windows | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 1 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by javier@…):
* keywords: => windows
* needs_tests: 0 => 1
Comment:
Under linux, django will run fine with a sqlite database with a non-ascii
pathname. However, it will print out a UnicodeWarning. This is the output
of django manage.py runserver:
{{{
(...)
Django version 1.5.dev20120820010350, using settings
'ticket18661.settings'
Development server is running at http://127.0.0.1:8000/
Quit the server with CONTROL-C.
/home/kandinski/.virtualenvs/django-
bug-18661/src/django/django/db/backends/sqlite3/base.py:344:
UnicodeWarning: Unicode unequal comparison failed to convert both
arguments to Unicode - interpreting them as being unequal
if self.settings_dict['NAME'] != ":memory:":
[20/Aug/2012 01:25:08] "GET /admin/ HTTP/1.1" 200 3301
[20/Aug/2012 01:26:06] "GET /admin/auth/user/ HTTP/1.1" 200 6059
[20/Aug/2012 01:26:06] "GET /admin/jsi18n/ HTTP/1.1" 200 2164
[20/Aug/2012 01:26:13] "GET /admin/auth/user/add/ HTTP/1.1" 200 4615
[20/Aug/2012 01:26:13] "GET /admin/jsi18n/ HTTP/1.1" 200 2164
[20/Aug/2012 01:26:25] "POST /admin/auth/user/add/ HTTP/1.1" 302 0
[20/Aug/2012 01:26:25] "GET /admin/auth/user/2/ HTTP/1.1" 200 12995
[20/Aug/2012 01:26:25] "GET /admin/jsi18n/ HTTP/1.1" 200 2164
}}}
And a snippet from my settings:
{{{
# Django settings for ticket18661 project.
# coding: utf8
(...)
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3', # Add
'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
(...)
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/18661#comment:2>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" 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 https://groups.google.com/groups/opt_out.