#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.


Reply via email to