Wrong encoding in graphs and csv
Moderator: crythias
Wrong encoding in graphs and csv
Hi all! I have wrong encoding in graphs and CSV. I use UTF-8 encoding in Config.pm. PDF output is OK. Can you please advise the problem? Thanks.
mysql> status;
--------------
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
mysql> SHOW VARIABLES LIKE "character_set_%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
Apache> AddDefaultCharset UTF-8
OTRS 3.0.11
mysql> status;
--------------
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
mysql> SHOW VARIABLES LIKE "character_set_%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
Apache> AddDefaultCharset UTF-8
OTRS 3.0.11
Last edited by majo053 on 28 Dec 2011, 19:57, edited 1 time in total.
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)
Re: Wrong encoding in graphs and csv
Pls check if you have installed needed charactor fonts on you "Operating System".
Mshi
Mshi
OTRS: 3.0.7
ITSM: 3.0.2
Running on: Ubuntu 10.04 LTS with MySQL, integrated with MS 2003 Active Directory Server
ITSM: 3.0.2
Running on: Ubuntu 10.04 LTS with MySQL, integrated with MS 2003 Active Directory Server
Re: Wrong encoding in graphs and csv
Do you mean this?
[root@otrs otrs]# find . -iname "*.ttf"
./var/fonts/DejaVuSans.ttf
./var/fonts/DejaVuSansMono-Oblique.ttf
./var/fonts/DejaVuSans-Bold.ttf
./var/fonts/DejaVuSans-BoldOblique.ttf
./var/fonts/DejaVuSans-Oblique.ttf
./var/fonts/DejaVuSansMono-BoldOblique.ttf
./var/fonts/DejaVuSansMono.ttf
./var/fonts/DejaVuSansMono-Bold.ttf
PS: I have OS Centos 6.1.
[root@otrs otrs]# find . -iname "*.ttf"
./var/fonts/DejaVuSans.ttf
./var/fonts/DejaVuSansMono-Oblique.ttf
./var/fonts/DejaVuSans-Bold.ttf
./var/fonts/DejaVuSans-BoldOblique.ttf
./var/fonts/DejaVuSans-Oblique.ttf
./var/fonts/DejaVuSansMono-BoldOblique.ttf
./var/fonts/DejaVuSansMono.ttf
./var/fonts/DejaVuSansMono-Bold.ttf
PS: I have OS Centos 6.1.
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)
Re: Wrong encoding in graphs and csv
Can you please someone help me?
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)
-
- Znuny expert
- Posts: 191
- Joined: 05 Jul 2011, 16:10
- Znuny Version: 3.2.2
- Real Name: Micshi
- Location: Beijing
- Contact:
Re: Wrong encoding in graphs and csv
Hi,
open microsoft excel first, then import your csv file into excel, when importing csv file you should select utf8 encode.
micshi
open microsoft excel first, then import your csv file into excel, when importing csv file you should select utf8 encode.
micshi
OTRS 3.2.2, ITSM 3.2.2, SystemMonitor
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance
Re: Wrong encoding in graphs and csv
Yes I know this. My problem is GD graphs. Where is problem?
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)
-
- Znuny expert
- Posts: 191
- Joined: 05 Jul 2011, 16:10
- Znuny Version: 3.2.2
- Real Name: Micshi
- Location: Beijing
- Contact:
Re: Wrong encoding in graphs and csv
Could you post a screen shot for your graph?
Micshi
Micshi
OTRS 3.2.2, ITSM 3.2.2, SystemMonitor
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance
Re: Wrong encoding in graphs and csv
Of course!
From left: incident, neurčený, žiadosť o službu, žiadosť o zmenu
From left: incident, neurčený, žiadosť o službu, žiadosť o zmenu
You do not have the required permissions to view the files attached to this post.
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)
-
- Znuny expert
- Posts: 191
- Joined: 05 Jul 2011, 16:10
- Znuny Version: 3.2.2
- Real Name: Micshi
- Location: Beijing
- Contact:
Re: Wrong encoding in graphs and csv
Thanks for your screen shot.
I am sure it's a bug since I can reproduce this issue.
Thanks,
micshi
I am sure it's a bug since I can reproduce this issue.
Thanks,
micshi
OTRS 3.2.2, ITSM 3.2.2, SystemMonitor
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance
Re: Wrong encoding in graphs and csv
Thanks micshi. Please where i find this bug report?
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)
-
- Znuny expert
- Posts: 191
- Joined: 05 Jul 2011, 16:10
- Znuny Version: 3.2.2
- Real Name: Micshi
- Location: Beijing
- Contact:
Re: Wrong encoding in graphs and csv
OTRS 3.2.2, ITSM 3.2.2, SystemMonitor
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance
Re: Wrong encoding in graphs and csv
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)
Re: Wrong encoding in graphs and csv
Hi,
This is actually already fixed in OTRS 3.1.x and upcoming 3.0.12.
You could address this issue on your system by replacing the file
/opt/otrs/Kernel/System/Stats.pm with the one from CVS:
http://source.otrs.org/viewvc.cgi/otrs/ ... ev=rel-3_0
Previously, GD used a built-in font that did not have glyphs for non-western
characters. Now we use a font that does. Also, the fonts look much better now.
Please try the fix and let me know if it works for you!
--
Mike
*** This bug has been marked as a duplicate of bug 3804 ***
This is actually already fixed in OTRS 3.1.x and upcoming 3.0.12.
You could address this issue on your system by replacing the file
/opt/otrs/Kernel/System/Stats.pm with the one from CVS:
http://source.otrs.org/viewvc.cgi/otrs/ ... ev=rel-3_0
Previously, GD used a built-in font that did not have glyphs for non-western
characters. Now we use a font that does. Also, the fonts look much better now.
Please try the fix and let me know if it works for you!
--
Mike
*** This bug has been marked as a duplicate of bug 3804 ***
huntingbears.nl - @michielbeijen on Twitter