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

Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

Data360 Analyze: Log4j Vulnerabilities (CVE-2021-44228, CVE-2021-45046, CVE-2021-4104, CVE-2021-45105 and CVE-2021-44832)
Data360 Analyze: important note before upgrading to 3.8.0
Data360 Analyze Migrations Package
Data360 Analyze Welcome Pack
Precautions to take before upgrading to Data360 Analyze 3.6.0 Server
Access to the 'function:login' is denied. Required:xPossessing:
When exporting dataflows from one Environment to Another Environment passwords are not exported properly
Error Code: org.infinispan.commons.cacheException
WebApplicationContext for namespace "main-servlet"
Data360 Analyze - How to check if a field exists and add it if it doesn't

Error Connecting to MS Access via JDBC to Unicode Data

Adrian Williams

May 06, 2020 09:14
Updated

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.

Articles in this section

Related articles