Charset Conversion Error

[djamadeus]

The same issue described and solved here:
exasol/mysql-virtual-schema#26
also exists with this adapter.
ETL-3009: [Column=13 Row=2] [Charset conversion from 'UTF-8' to 'ASCII' failed [Invalid or incomplete multibyte or wide character]]

Switching back to 9.0.4-release solved the problem for me.

[redcatbear]

@djamadeus, I am going to release version 2.1.0 in a couple of minutes. This version uses the latest virtual-schema-common-jdbc library that contains a Virtual Schema property called IMPORT_DATA_TYPES.

You can use that to switch between the two variants of result set type calculation, either calculated by Exasol or inferred from JDBC metadata. While the later mechanism is less efficient, it handles situation in a more forgiving way where the JDBC driver reports character set information inconsistently.

[redcatbear]

Version 2.1.0 is released.

[djamadeus]

awesome. will run some teste between holidays and give you feedback.