# Display European characters correctly in Dremio

**URL:** <https://community.dremio.com/t/display-european-characters-correctly-in-dremio/9906>\
**Category:** Uncategorized\
**Created:** [November 3, 2022, 8:21pm UTC](https://community.dremio.com/t/display-european-characters-correctly-in-dremio/9906 "2022-11-03T20:21:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ajayacharya](https://avatars.discourse-cdn.com/v4/letter/a/f4b2a3/32.png) [@ajayacharya](https://community.dremio.com/u/ajayacharya)\
**Post date:** [November 3, 2022, 8:21pm UTC](https://community.dremio.com/t/display-european-characters-correctly-in-dremio/9906/1 "2022-11-03T20:21:15Z")

</div>

Hi,

I am trying to store European characters in Dremio. I found that characters are being changes as � or ‘’ or other character once being stored /read in dremio.

Can you please help me on how to store the data correctly.  
I tried to load from Excel, csv or load from pandas . But none of them worked.  
I also tried to load from S3 into dremio. But the same issue.

Can anyone please help me.

Thanks

---

<div class="post-metadata">

**Author:** ![fetanchaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/fetanchaud/32/4192_2.png) [@fetanchaud](https://community.dremio.com/u/fetanchaud)\
**Post date:** [November 4, 2022, 11:09am UTC](https://community.dremio.com/t/display-european-characters-correctly-in-dremio/9906/2 "2022-11-04T11:09:59Z")

</div>

Hi @ajayacharya , are your files encoded in UTF-8 ?  
I once had this problem with ASCII encoded files.

---

<div class="post-metadata">

**Author:** ![bobp](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/bobp/32/4486_2.png) [@bobp](https://community.dremio.com/u/bobp)\
**Post date:** [November 8, 2022, 8:28pm UTC](https://community.dremio.com/t/display-european-characters-correctly-in-dremio/9906/3 "2022-11-08T20:28:17Z")

</div>

Hi @ajayacharya  
If the information is stored correctly in the underlying files, note that your shell environment matters to display the information.

You’ll need to export the following variable to display UTF-8 correctly:

export LANG=en\_US.UTF-8  
export LC\_CTYPE=en\_US.UTF-8

(en\_US.UTF-8 is the example from my setup).

Thanks,  
bob