Symptom:
When using the JDBC Node to connect to MS Access to access unicode data, this error can occur:
ERROR: Input length = 1
ERROR: error on row 0, com.lavastorm.io.data.FieldWritingException:Error occurred writing the field (text), type (class java.lang.String) on record (<nnnn>). Field had the value (<field_value>)
Solution:
On the JDBC Query node, check the Optional->DefaultToUnicode parameter is set to 'true' (which is also the default value).
Comments
0 comments
Please sign in to leave a comment.