# Failed to encode '中山市' in character set 'ISO-8859-1' **URL:** \ **Category:** Uncategorized\ **Created:** [February 14, 2019, 8:29am UTC](https://community.dremio.com/t/failed-to-encode-in-character-set-iso-8859-1/2776 "2019-02-14T08:29:19Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![JohnYan2017](https://avatars.discourse-cdn.com/v4/letter/j/a183cd/32.png) [@JohnYan2017](https://community.dremio.com/u/JohnYan2017)\ **Post date:** [February 14, 2019, 8:29am UTC](https://community.dremio.com/t/failed-to-encode-in-character-set-iso-8859-1/2776/1 "2019-02-14T08:29:19Z")
Hell Dremio how can I solve this problem in query ---
**Author:** ![asm](https://avatars.discourse-cdn.com/v4/letter/a/278dde/32.png) [@asm](https://community.dremio.com/u/asm)\ **Post date:** [February 14, 2019, 1:49pm UTC](https://community.dremio.com/t/failed-to-encode-in-character-set-iso-8859-1/2776/2 "2019-02-14T13:49:55Z")
Hi, Try to change default encoding to UTF-16 as follows: > [@How to support UTF8 encoding format?](https://community.dremio.com/t/how-to-support-utf8-encoding-format/543/10): > > Hi, You can change calcite default encoding via custom java option in dremio-env configuration file. Here is example how set encoding to UTF-16: DREMIO\_JAVA\_SERVER\_EXTRA\_OPTS=’-Dsaffron.default.charset=UTF-16LE -Dsaffron.default.nationalcharset=UTF-16LE -Dsaffron.default.collation.name=UTF-16LE$en\_US’ ---
**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\ **Post date:** [February 14, 2019, 6:06pm UTC](https://community.dremio.com/t/failed-to-encode-in-character-set-iso-8859-1/2776/3 "2019-02-14T18:06:45Z")
Hi @asm Did you restart Dremio after making this change? ---
**Author:** ![asm](https://avatars.discourse-cdn.com/v4/letter/a/278dde/32.png) [@asm](https://community.dremio.com/u/asm)\ **Post date:** [February 15, 2019, 11:05am UTC](https://community.dremio.com/t/failed-to-encode-in-character-set-iso-8859-1/2776/4 "2019-02-15T11:05:36Z")
Hi @ben Yes, restart is required to apply new settings. ---
**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\ **Post date:** [February 15, 2019, 4:27pm UTC](https://community.dremio.com/t/failed-to-encode-in-character-set-iso-8859-1/2776/5 "2019-02-15T16:27:50Z")
@JohnYan2017, Did you have success with @asm’s suggested solution? ---
**Author:** ![tkosin](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/tkosin/32/1928_2.png) [@tkosin](https://community.dremio.com/u/tkosin)\ **Post date:** [September 28, 2019, 4:44am UTC](https://community.dremio.com/t/failed-to-encode-in-character-set-iso-8859-1/2776/6 "2019-09-28T04:44:29Z")
Hi @ben, I have the same problem on “[Failed to encode … in character set ‘ISO-8859-1’]” when I try to group or keep only by the value of Thai character. Configuration on dremio-env has been done `DREMIO_JAVA_SERVER_EXTRA_OPTS='-Dsaffron.default.charset=UTF-16LE -Dsaffron.default.nationalcharset=UTF-16LE -Dsaffron.default.collation.name=UTF-16LE$en_US'` and restart Dremio already. Cannot resolve the issue. Here is my environment: - Dremio on Windows - Data source is SQL Server If you have another suggestion please guide me to solve. Thank you. ![Thai%20Bkk%20problem%20on%20Dremio%20OSS](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/1/17f364e8ce9d0c73b99f5eea6d4a6f5a62170fc5.png) ---
**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\ **Post date:** [October 2, 2019, 6:00pm UTC](https://community.dremio.com/t/failed-to-encode-in-character-set-iso-8859-1/2776/7 "2019-10-02T18:00:05Z")
Hello @tkosin, I just checked my local Dremio 4.0 install on Mac with these options and I did not experience the issue. I’m wondering if Dremio is picking up the configuration change you made. Can you open your terminal, use `jps` to determine the Dremio Java process ID and then use `jinfo -flags ` to determine what options are actually passed to Dremio? [Here for details on using the Java tools I just described.](https://dzone.com/articles/jinfo-command-line-peeking-jvm)