olp1 import does not work when special characters in file name

[Andreas Preikschat]

Hello,

When you try to import a olp file (OpenLP version 1 importer) and the file contains for example "ö" the importer will fail. (Yes I know, normally the file is named songs.olp, that's why I set this to "low".)

Here the traceback for OpenLP-1.9.12-bzr2081-setup.exe:

Traceback (most recent call last):
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.core.ui.wizard", line 187, in onCurrentIdChanged
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.plugins.songs.forms.songimportform", line 390, in performWizard
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.plugins.songs.lib.olp1import", line 80, in doImport
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\out00-PYZ.pyz\sqlite", line 61, in connect
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\out00-PYZ.pyz\sqlite.main", line 445, in __init__
UnicodeEncodeError: 'ascii' codec can't encode characters in position 7-15: ordinal not in range(128)

[matysek (mzibricky)]

I verified this issue with latest nightly build and it is still there. I tried different experiments and it seems like the issue is with the 'sqlite' (reads sqlite 2 db format) python module which is not able to handle unicode filenames of sqlite databases.

This module is old and unsupported. It very unlikely that this would be fixed in the 'sqlite' module. We are not able to fix this issue and thus setting status as wontfix.