[Bug 195006] New: national charaters not accepted in database file path

https://bugs.kde.org/show_bug.cgi?id=195006

           Summary: national charaters not accepted in database file path
           Product: digikam
           Version: unspecified
          Platform: unspecified
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: [hidden email]
        ReportedBy: [hidden email]


Version:           0.10.0 (rev.: wyeksportowane) (using 4.2.3 (KDE 4.2.3),
[hidden email])
Compiler:          gcc
OS:                Linux (i686) release 2.6.28.10

in 0.10 series it is not possible to use national characters in database file
path.
It is however possible to use national characters in collection path.
I'm attaching screen-shoot of error message when someone is trying to use
national characters in database file path.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #1 from Andrzej <superandrzej epf pl>  2009-06-02 18:34:20 ---
Created an attachment (id=34203)
 --> (http://bugs.kde.org/attachment.cgi?id=34203)
error message

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=195006


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|general                     |Database
            Version|unspecified                 |0.10.0




--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #2 from Gilles Caulier <caulier gilles gmail com>  2009-06-19 12:01:18 ---
Andrzej,

What do you mean by "national characters" ?

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #3 from Andrzej <superandrzej epf pl>  2009-06-19 14:19:30 ---
in my case Polish characters like: ąćęłńśóżź
e.g. "photos" in Polish is "zdjęcia" and I cannot place database file in a
directory named like this.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=195006


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever Confirmed|0                           |1




--- Comment #4 from Gilles Caulier <caulier gilles gmail com>  2009-06-19 14:44:52 ---
I confirm dysfunction

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=195006


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #5 from Gilles Caulier <caulier gilles gmail com>  2009-06-19 15:10:56 ---
Marcel,

I cannot found where digiKam code is weird here. We pass dtabase path as
QString... So the problem must be in sqlite or Qt4 Database driver...

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #6 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-07-31 22:23:32 ---
I have just tested to create a database in my russian-polish testing directory
"Мои рисунки ąćęłńśóżź" and this worked without any problem. My system is
Opensuse, system charset is UTF8. Maybe this is a problem at a lower level?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #7 from Andrzej <superandrzej epf pl>  2009-08-03 22:18:19 ---
I use LANG=pl_PL that by default uses ISO 8859-2

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Francesco Riosa-2]

https://bugs.kde.org/show_bug.cgi?id=195006


Francesco Riosa <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
                 CC|                            |[hidden email]
         Resolution|                            |FIXED




--- Comment #8 from Francesco Riosa <francesco+kde pnpitalia it>  2011-06-29 12:54:39 ---
2.0.0-rc is out, please re-open if needed

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=195006


Andrzej <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|FIXED                       |




--- Comment #9 from Andrzej <superandrzej epf pl>  2011-10-06 22:00:10 ---
Still present in Digikam 2.2.o

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #10 from Marcel Wiesweg <marcel wiesweg gmx de>  2011-10-07 16:14:19 ---
Andrezej: SQLite or MySQL?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #11 from Andrzej <superandrzej epf pl>  2011-10-07 23:08:16 ---
SQLite

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #12 from Marcel Wiesweg <marcel wiesweg gmx de>  2011-10-29 15:38:55 ---
Qt is internally 100% UTF-16, and the filename in the database driver is passed
to sqlite3_open_v2 as UTF-8. So I dont see anything we can do in digikam about
this. I have only used UTF-8 systems in the last years, perhaps someone with
experience in non-UTF-8 can help us here.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=195006


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #13 from Gilles Caulier <caulier gilles gmail com>  2011-12-15 08:51:54 ---
Andrzej,

It still valid using digiKam 2.4 ?

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #14 from Andrzej <superandrzej epf pl>  2012-01-12 22:26:37 ---
Gilles,

Yes it is still valid using digiKam 2.4.

I know where exactly problem is:
In digikamrc database location is stored in UTF8.

in my case:
/D/zdjęcia/

is stored like this:
Database Name=/D/zdjęcia/
Database Name Thumbnails=/D/zdjęcia/

This is UTF8 encodings seen in ISO 8859-2 locale.

so the solution would be convert the path stored in UTF8 in to current locale
encodings just before accessing the database. In my case UTF8 -> ISO 8859-2.

Apparently now digiKam instead of looking for /D/zdjęcia/ is looking for
/D/zdjęcia/ that does not exit.

To confirm this I created symlink to /D/zdjęcia/ called /D/zdjęcia/ and
digiKam had no problem in finding the location.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=195006


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|0.10.0                      |2.4.1




--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #15 from Marcel Wiesweg <marcel wiesweg gmx de>  2012-01-13 09:16:47 ---
If you start digikam on the console, it will output the database parameters:
digikam(9021)/digikam (core) Digikam::AlbumManager::setDatabase:
DatabaseParameters: [ Type "QSQLITE", Name "/media/fotos/digikam4.db"
(Thumbnails Name "/media/fotos/thumbnails-digikam.db"); ]

What does it say for you?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #16 from Andrzej <superandrzej epf pl>  2012-01-19 07:58:27 ---
digikam(1786)/digikam (core): Error while opening the database. Error details [
QSqlError(-1, "Błąd podczas otwierania bazy danych", "unable to open database
file") ]
digikam(1786)/digikam (core): Error while opening the database. Error details [
QSqlError(-1, "Błąd podczas otwierania bazy danych", "unable to open database
file") ]
digikam(1786)/digikam (core): Error while opening the database. Error details [
QSqlError(-1, "Błąd podczas otwierania bazy danych", "unable to open database
file") ]

and so on

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=195006





--- Comment #17 from Marcel Wiesweg <marcel wiesweg gmx de>  2012-01-19 21:21:14 ---
ensure 50003 is enabled in kdebugdialog. It must be among the first few lines,
before any db errors.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel