Dremio character set 'ISO-8859-1'

I m getting the following error : “Failed to encode ‘NBC Universal – NBC News’ in character set ‘ISO-8859-1’” While running the following query :

SELECT ‘NBC Universal – NBC News’

I have posted same question on stackoverflow with more details stackoverflow

Solutions already mentioned on the forum are not working

The only issue with other responses posted , is that $ in the config needs to be escaped :

DREMIO_JAVA_SERVER_EXTRA_OPTS=“-Dsaffron.default.charset=UTF-16LE -Dsaffron.default.nationalcharset=UTF-16LE -Dsaffron.default.collation.name=UTF-16LE\$en_US”

1 Like