Malformed UTF-8 characters. Possibly incorrectly encoded

WriteBackExtreme only supports data in UTF-8 Encoding. When your database table has characters other than UTF-8 this error message may be displayed.

Databricks Users:

If you are using DataBricks this issue may happen when you are using Paragraph fields (long text fields). The default max string length of the ODBC driver is 255 characters. When you use the Paragraph field in WriteBackExtreme you can go up to 4000 characters and this will break the ODBC driver.

You can fix this by adding the following setting to your ODBC configuration:

Windows see section K: https://docs.infotopics.com/writebackextreme/product-guide/database-connections/databricks/windowsarrow-up-right

Linux see DefaultStringColumnLength: https://docs.infotopics.com/writebackextreme/product-guide/database-connections/databricks/linuxarrow-up-right

If above does not work you can also add it in the Management Console:

Last updated

Was this helpful?