Database migration error due to 4byte UTF in filename

[Brian J Hoskins]

Digikam experts,

I have encountered an error in database migration (SQLite to MySQL)
which I would like to share.

During the database migration, when the "Copy Images..." step is
progressing, I receive the following complaint from the migration tool:

*-----*
*/Error while converting the database./**/
/**/Details: Incorrect string value: '\xF0\x9F\x92\xA6\xF0\x9F...' for
column 'name' at row 1
/-----/
/*
The complaint suggested a 4-byte UTF character F09F92A6.  I looked that
up and it's an Emoji (:sweat_drops:) character. See below:

http://www.fileformat.info/info/unicode/char/1f4a6/index.htm

This is what happens when you allow children to name files.

I am wondering if this error occurs because the MySQL database is
limited to three byte UTF characters.  If so, my suggestions are:

* Modify the database schema to allow 4 byte UTF characters
OR...
* Create a more user-friendly error message for this event (most users
probably not able to decipher it).

I would imagine this is a rare error among Digikam users.  It's possible
I'm the only one who has encountered it.  So low priority for sure.

Thanks,

Brian.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20170108/3e9700ec/attachment.html>