# Chinese character not support in sql with ' like '%chinese characters%' '

**URL:** <https://community.dremio.com/t/chinese-character-not-support-in-sql-with-like-chinese-characters/1828>\
**Category:** Uncategorized\
**Created:** [September 13, 2018, 3:50am UTC](https://community.dremio.com/t/chinese-character-not-support-in-sql-with-like-chinese-characters/1828 "2018-09-13T03:50:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zhang\_maosen](https://avatars.discourse-cdn.com/v4/letter/z/e99b99/32.png) [@zhang\_maosen](https://community.dremio.com/u/zhang_maosen)\
**Post date:** [September 13, 2018, 3:50am UTC](https://community.dremio.com/t/chinese-character-not-support-in-sql-with-like-chinese-characters/1828/1 "2018-09-13T03:50:07Z")

</div>

chinese character not support in sql with ’ like ‘%chinese characters%’ ', how to solve it?  
this is error:

Caused by: org.apache.calcite.runtime.CalciteException: Failed to encode ‘._?\Q7天\E._?’ in character set ‘ISO-8859-1’

thanks

---

<div class="post-metadata">

**Author:** ![anthony](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/anthony/32/670_2.png) [@anthony](https://community.dremio.com/u/anthony)\
**Post date:** [September 14, 2018, 1:24pm UTC](https://community.dremio.com/t/chinese-character-not-support-in-sql-with-like-chinese-characters/1828/2 "2018-09-14T13:24:18Z")

</div>

It seems like you are running into a similar issue [mentioned here](https://community.dremio.com/t/how-to-support-utf8-encoding-format/543). If so, this is something not supported today but we are tracking as an enhancement.
