# Non english text with postgresql

**URL:** <https://community.dreamfactory.com/t/non-english-text-with-postgresql/1188>\
**Category:** Connecting to SQL\
**Created:** [June 14, 2015, 3:07pm UTC](https://community.dreamfactory.com/t/non-english-text-with-postgresql/1188 "2015-06-14T15:07:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ran](https://avatars.discourse-cdn.com/v4/letter/r/a9adbd/32.png) [@ran](https://community.dreamfactory.com/u/ran)\
**Post date:** [June 14, 2015, 3:07pm UTC](https://community.dreamfactory.com/t/non-english-text-with-postgresql/1188/1 "2015-06-14T15:07:49Z")

</div>

Hi, I’m using the latest dream factory with postgresql  
I’m getting dream factory response for non english char as their unicode number like \u05db  
I read in the docs about supports\_multibyte not sure if that related supports\_multibyte is false  
but i cant find national type for postgresql my fields are of type text and my db encoding is utf8

thanks

---

<div class="post-metadata">

**Author:** ![ran](https://avatars.discourse-cdn.com/v4/letter/r/a9adbd/32.png) [@ran](https://community.dreamfactory.com/u/ran)\
**Post date:** [June 15, 2015, 7:51am UTC](https://community.dreamfactory.com/t/non-english-text-with-postgresql/1188/2 "2015-06-15T07:51:05Z")

</div>

it seem the problem is phps json\_encode theres an option for JSON\_UNESCAPED\_UNICODE  
i think its in Utility/DataFormatter.php jsonEncode line 767 i changed it for myself, are there other places to edit? maybe add a config option to set this?

---

<div class="post-metadata">

**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\
**Post date:** [June 18, 2015, 3:24pm UTC](https://community.dreamfactory.com/t/non-english-text-with-postgresql/1188/3 "2015-06-18T15:24:52Z")

</div>

Did editing DataFormatter.php fix the issue for you, or did it not fix and you now think it may be elsewhere in the codebase also?

---

<div class="post-metadata">

**Author:** ![ran](https://avatars.discourse-cdn.com/v4/letter/r/a9adbd/32.png) [@ran](https://community.dreamfactory.com/u/ran)\
**Post date:** [June 19, 2015, 7:34am UTC](https://community.dreamfactory.com/t/non-english-text-with-postgresql/1188/4 "2015-06-19T07:34:23Z")

</div>

i tested simple gets and it fixed it not sure about any other cases like insertion  
i saw other json\_encode in the code im not sure if it may pass through it

---

<div class="post-metadata">

**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\
**Post date:** [June 23, 2015, 2:12pm UTC](https://community.dreamfactory.com/t/non-english-text-with-postgresql/1188/5 "2015-06-23T14:12:41Z")

</div>

Unfortunately we haven’t tested this, either. You’ll just have to test your use cases and identify if anything elsewhere in the code arises as a roadblock. If you accomplish this as a robust solution, I recommend contributing back to the open source codebase with your improvements.