# How can clover read in special character like Ö, ü, ç, ñ, ß

**URL:** <https://forum.cloverdx.com/t/how-can-clover-read-in-special-character-like-o-u-c-n-ss/1516>\
**Category:** CloverDX Platform\
**Created:** [November 9, 2014, 12:00am UTC](https://forum.cloverdx.com/t/how-can-clover-read-in-special-character-like-o-u-c-n-ss/1516 "2014-11-09T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![yichuansancun](https://avatars.discourse-cdn.com/v4/letter/y/8e7dd6/32.png) [@yichuansancun](https://forum.cloverdx.com/u/yichuansancun)\
**Post date:** [November 9, 2014, 12:00am UTC](https://forum.cloverdx.com/t/how-can-clover-read-in-special-character-like-o-u-c-n-ss/1516/1 "2014-11-09T00:00:00Z")

</div>

I tried with UTF - 8 but all the special characters became question marks when i use universal data writer and write to txt.  
I also tried with csv and spreadsheet reader. With csv, the characters turn into other special char so didnit preserve the original. And with spreadsheet reader, the special characters are preserved, but changed some regular letters to ?.

With the spreadsheet reader, when I viewed the debug data, those characters are just fine. But when I open the output file in excel, the ? marks start to appear.

Why is that?

---

<div class="post-metadata">

**Author:** ![slechtaj](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@slechtaj](https://forum.cloverdx.com/u/slechtaj)\
**Post date:** [November 10, 2014, 12:39pm UTC](https://forum.cloverdx.com/t/how-can-clover-read-in-special-character-like-o-u-c-n-ss/1516/2 "2014-11-10T12:39:41Z")

</div>

Hi,

UTF-8 charset has to be set on both reader and writer components. You can try to open created file with your system editor. See attached example.

Hope this helps.

- [ReadChars.zip](https://cdn.cloverdx.com/forum/16494%5F7b8d4ad2888c7f7ef8aed73abfa38c27/ReadChars.zip)

---

<div class="post-metadata">

**Author:** ![yichuansancun](https://avatars.discourse-cdn.com/v4/letter/y/8e7dd6/32.png) [@yichuansancun](https://forum.cloverdx.com/u/yichuansancun)\
**Post date:** [November 10, 2014, 4:32pm UTC](https://forum.cloverdx.com/t/how-can-clover-read-in-special-character-like-o-u-c-n-ss/1516/3 "2014-11-10T16:32:28Z")

</div>

thanks!
