We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Articles in this section

See more

Error Connecting to MS Access via JDBC to Unicode Data

Avatar
Adrian Williams
  • Updated
Follow

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.