# Chinese character

**URL:** <https://www.dolibarr.org/forum/t/chinese-character/19946>\
**Category:** Installing my Dolibarr\
**Created:** [December 17, 2020, 4:13pm UTC](https://www.dolibarr.org/forum/t/chinese-character/19946 "2020-12-17T16:13:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![chrisfrench007](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/c/4bbf92/32.png) [@chrisfrench007](https://www.dolibarr.org/forum/u/chrisfrench007)\
**Post date:** [December 17, 2020, 4:13pm UTC](https://www.dolibarr.org/forum/t/chinese-character/19946/1 "2020-12-17T16:13:29Z")

</div>

I need to input chinese character to designate adress of shipment in Purchase POrder  
I get some ??? instead.  
Initially during the install the db was not in UTF8. So I converted it with Operations tab in PHPMyadmin to take a UTF8-General, but still get some ???  
I particularly get this in PDF genetation and in field being filled

---

<div class="post-metadata">

**Author:** ![itstmyi](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/i/90ced4/32.png) [@itstmyi](https://www.dolibarr.org/forum/u/itstmyi)\
**Post date:** [December 18, 2020, 12:41am UTC](https://www.dolibarr.org/forum/t/chinese-character/19946/2 "2020-12-18T00:41:05Z")

</div>

I think I have the same problem . for example ，Dolibarr generates document for some objects (project), if the object name is Chinese , it would be shown wrongly .

---

<div class="post-metadata">

**Author:** ![chrisfrench007](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/c/4bbf92/32.png) [@chrisfrench007](https://www.dolibarr.org/forum/u/chrisfrench007)\
**Post date:** [December 18, 2020, 1:05am UTC](https://www.dolibarr.org/forum/t/chinese-character/19946/3 "2020-12-18T01:05:50Z")

</div>

I found out partly how to solve this :  
First you need to have any field in the database which is suppose to contain chinese character to be set as utf8\_unicode\_ci  
Main problem: when you set up the database with the dolibarr install it create latin1 field, I tried to change the database char set but unfortunately i could only easily change it to tables not to rows… so in my case what i did was to locate where the field i wanted to contain chinese was in the database and i changed manually the char set for those fields… this is a painfull process believe me.  
For the PDF issue i found out in some other topic that some lang files must be edited. Problem I have now is that I success to get some chinese pdf but the font sucks and is ugly and I get an error on the top of my dolibar page as follow  
Error: /undefined in findresource Operand stack: --dict:15/24(L)-- F2 12.0 --dict:6/6(L)-- --dict:6/6(L)-- cid0cs-UniGB-UTF16-H --dict:10/12(ro)(G)-- --nostringval-- CIDFontObject --dict:7/7(L)-- --dict:7/7(L)-- Adobe-GB1 Execution stack: %interp\_exit .runexec2 --nostringval-- --nostringval-- --nostringval-- 2 %stopped\_push --nostringval-- --nostringval-- --nostringval-- false 1 %stopped\_push 1878 1 3 %oparray\_pop 1877 1 3 %oparray\_pop 1861 1 3 %oparray\_pop --nostringval-- --nostringval-- 2 1 1 --nostringval-- %for\_pos\_int\_continue --nostringval-- --nostringval-- --nostringval-- --nostringval-- %array\_continue --nostringval-- false 1 %stopped\_push --nostringval-- %loop\_continue --nostringval-- --nostringval-- --nostringval-- --nostringval-- --nostringval-- --nostringval-- %array\_continue --nostringval-- --nostringval-- --nostringval-- --nostringval-- --nostringval-- %loop\_continue Dictionary stack: --dict:1159/1684(ro)(G)-- --dict:1/20(G)-- --dict:75/200(L)-- --dict:75/200(L)-- --dict:108/127(ro)(G)-- --dict:288/300(ro)(G)-- --dict:22/25(L)-- --dict:6/8(L)-- --dict:26/40(L)-- Current allocation mode is local Last OS error: 2
