<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Digikam experts,<br>
<br>
I have encountered an error in database migration (SQLite to MySQL)
which I would like to share.<br>
<br>
During the database migration, when the "Copy Images..." step is
progressing, I receive the following complaint from the migration
tool:<br>
<br>
<b>-----</b><br>
<b><i>Error while converting the database.</i></b><b><i><br>
</i></b><b><i>Details: Incorrect string value:
'\xF0\x9F\x92\xA6\xF0\x9F...' for column 'name' at row 1<br>
</i>-----<i><br>
</i></b><br>
The complaint suggested a 4-byte UTF character F09F92A6. I looked
that up and it's an Emoji (:sweat_drops:) character. See below: <br>
<br>
<a class="moz-txt-link-freetext" href="http://www.fileformat.info/info/unicode/char/1f4a6/index.htm">http://www.fileformat.info/info/unicode/char/1f4a6/index.htm</a><br>
<br>
This is what happens when you allow children to name files.<br>
<br>
I am wondering if this error occurs because the MySQL database is
limited to three byte UTF characters. If so, my suggestions are:<br>
<br>
* Modify the database schema to allow 4 byte UTF characters<br>
OR...<br>
* Create a more user-friendly error message for this event (most
users probably not able to decipher it).<br>
<br>
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.<br>
<br>
Thanks,<br>
<br>
Brian.<br>
<br>
</body>
</html>