[Digikam-devel] [Bug 258409] Tags and TagsTree table is empty after DB migration from sqlite to mysql

Francesco Riosa francesco at pnpitalia.it
Sun May 8 21:57:01 BST 2011


--- Comment #13 from Francesco Riosa <francesco pnpitalia it>  2011-05-08 22:56:57 ---
(In reply to comment #12)
great work, I already encountered problems with collations and fixed part of
them, your tests show that create_index_if_not_exists still need to be made
more robust or collations forced.

"DELETE FROM TagsTree" as is delete all elements of TagsTree, not very nice,
need to find where it is and debug it.

Even more important, where things need to be case sensitive another collation
should be used possibly utf8_bin, but still need to investigate it deeply.
But this must be checked also with digikam for windows :(

If you use external database remember to add 
lower_case_table_names = 1
to the [mysqld] section, I don't know if it's really needed but may help (I
would remove that need in the future if possible).

Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

More information about the Digikam-devel mailing list