Forum GLPI-Project

clarkchan

Member

Registered: 2009-02-25

Posts: 9

Chinese in GLPI

Hi all, I have several question would like to ask:
1. I input the devices by hand in Chinese without a problem, but when I use the system to export to PDF or SLK files, the characters become unviewable.
2. When I use the plugin "File injection" to import data with Chinese character, the result will be some unviewable characters in the system.
Thank you all!

remi

GLPI-DEV

From: Champagne

Registered: 2007-04-28

Posts: 7,127

Website

Re: Chinese in GLPI

What is the encoding of your file ?

The data_injection only know ISO-8859-1 and UTF-8.
Have you try an UTF-8 csv file wihtout using the "auto-detect" feature ?

+

---

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

hao3w

Member

Registered: 2009-02-27

Posts: 8

Re: Chinese in GLPI

I have activated ocs tool in GLPI and it works, imported some detail inforamtion of each computer into GLPI,but in GLPI web control panel the Chinese characters become unviewable characters,in OCSNG website,they can be shown correctly.
Anyone know how to make the Chinese inforamtion imported from OCS be shown correctly in GLPI website? Thanks for any useful information!!

remi

GLPI-DEV

From: Champagne

Registered: 2007-04-28

Posts: 7,127

Website

Re: Chinese in GLPI

GLPI is full UTF-8
OCS use an ISO-8859-1 database to store UTF-8 which is a big issue...

GLPI is designed to work with this configuration.

Have you hack OCS ? (there is some discussion how to change OCS to UTF-8 in the OCS forum).
If yes, GLPI couldn't work without change the code
If no, which are the data unviewable ? What is the content of the OCS DB ?

Another idea : what is your MySQL configuration encoding (most installation comme with latin1)
What is the result of the SQL command

show variables like 'character%';

+

---

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

clarkchan

Member

Registered: 2009-02-25

Posts: 9

Re: Chinese in GLPI

Hello Remi, thank you for your reply, now I can use OpenOffice open the file exported using UTF-8, and the character. But after using the same file to add new records and use file injection to import it again. It shows injection successfully, but I cannot see any new record inside the system. I noticed that the system log has recorded down I have perform a file injection to a table. Looking forward to your reply, thank you!