I think there is a bug when executing a SQL insert script via Tools -> Import SQL data. There is no option for checking UTF-8 and the imported UTF-8 data gets corrupted in the database.
if you export data with "UTF-8 encoding" checked in "Data Export" dialog (or by using the "-UTF8" cli option), the "Import SQL data" tool will import the file as UTF-8 data.
If it's not checked, the import tool assumes the file to be encoded with the system encoding. You may however change the system encoding by using the java option "-Dfile.encoding=utf-8", see https://sourceforge.net/p/jailer/discussion/700499/thread/b48d2c30/?limit=25#8297
HTH,
Ralf
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
if you export data with "UTF-8 encoding" checked in "Data Export" dialog (or by using the "-UTF8" cli option), the "Import SQL data" tool will import the file as UTF-8 data.
If it's not checked, the import tool assumes the file to be encoded with the system encoding. You may however change the system encoding by using the java option "-Dfile.encoding=utf-8", see
https://sourceforge.net/p/jailer/discussion/700499/thread/b48d2c30/?limit=25#8297
HTH,
Ralf
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
Hi,
thanks for your feedback. The SQL export was not created with Jailer. So I will give the java option a try. Thanks for the hint.
Kind regards
Frank Opitz
Last edit: Anonymous 2018-02-27