#2 Support for utf8mb4

[Niels Timmers]

Hello,

We use utf8mb4 as charset for our database, but it appears this is not supported by Jailer? When i convert the data to utf8 it seems to be working. Is there something i can do to get it to work in utf8mb4?

I open the table in the Jailer Data Browser, with a column with the value "tést ©". See the attachment for the exact results. In UTF8 it perfectly shows "tést ©", but in UTF8mb4 it shows "tést ©". I tried the -UTF8 parameter, and -Dfile.encoding=UTF8 in jailer.sh, but as it is also not working in the Data Browser i guess it is not just the export.

[Ralf Wisser]

Hi,

what DBMS do you use?

[Ralf Wisser]

Hi, if it's MySQL, please try a JDBC-URL like
jdbc:mysql://x.x.x.x:3306/db?useUnicode=true&characterEncoding=utf8mb4
see https://stackoverflow.com/questions/44591895/utf8mb4-in-mysql-workbench-and-jdbc

[Niels Timmers]

Hi Ralf, thank you! We indeed use MySQL, and your solution seems to be working for the Data Browser. Howerver i am still unable to use this parameter in the commandline export, but i will try some more.

[Niels Timmers]

Yes! It works! Thank you!
I was able to export using the following commandline:

jailer.sh export "../'.$uniqid.'/template_personal.csv" org.gjt.mm.mysql.Driver "jdbc:mysql://'.$host.':3306/'.$db.'?useUnicode=true&characterEncoding=utf8" '.$username.' '.$password.' -jdbcjar "lib/mysql-connector-java-5.1.5-bin.jar" -e "../'.$uniqid.'/dump.sql"