Problem storing UTF greek chars in mysql using otrs 2.0.4
Hello everyone, I have installed otrs 2.0.4 on a CENTOS 4.2 using mysql 4.1.12 Mysql was installed from the distribution rpms. I have followed the directions in the otrs faq regarding the use of utf in http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ID=52 where it is mentioned to: - make changes in Kernel/Config.pm $Self->{DefaultCharset} = 'utf-8'; - make changes in /etc/my.cnf [mysqld] default-character-set = utf8 I then created the mysql database following the instruction in the README.database document. So far, so good. I can display and search greek text in tickets from the web interface without problems. This is my problem: I *cannot see* the greek chars that are stored in the database from the mysql command line. When I do something like "select from article" I get hieroglyphics/unreadable and since they are not stored in greek it is impossible to do sql queries. I know that utf works in mysql because: mysql> SHOW VARIABLES LIKE "character_set_%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | I apologize for the long message. Any ideas on where to look next ? Thank you, Stelios
Maistros Stelios wrote:
So far, so good. I can display and search greek text in tickets from the web interface without problems.
This is my problem:
I *cannot see* the greek chars that are stored in the database from the mysql command line. When I do something like "select from article" I get hieroglyphics/unreadable and since they are not stored in greek it is impossible to do sql queries.
Maybe the commandline doesn't support utf-8? Have you tried something like phpMyAdmin? Nils Breunese.
Hi Stelios, OTRS doesn't actually support UTF-8 "100% correct", meaning that OTRS stores UTF-8-characters double-encoded in the MySQL-DB. This is described several bug reports and also in the mailing lists (don't know if german or english, month 11/2005 to 02/2006??) In my opinion, you can setup OTRS to use UTF-8 (especially if you have the need like you) but you must do some fixing: * very important, set the right character set on DB-connection http://bugs.otrs.org/show_bug.cgi?id=1035 * implement an attachement-bugfix when you use filesystem-article-storage Bye, Alex Maistros Stelios schrieb:
Hello everyone,
I have installed otrs 2.0.4 on a CENTOS 4.2 using mysql 4.1.12 Mysql was installed from the distribution rpms.
I have followed the directions in the otrs faq regarding the use of utf in http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ID=52 where it is mentioned to:
- make changes in Kernel/Config.pm $Self->{DefaultCharset} = 'utf-8';
- make changes in /etc/my.cnf [mysqld] default-character-set = utf8
I then created the mysql database following the instruction in the README.database document.
So far, so good. I can display and search greek text in tickets from the web interface without problems.
This is my problem:
I *cannot see* the greek chars that are stored in the database from the mysql command line. When I do something like "select from article" I get hieroglyphics/unreadable and since they are not stored in greek it is impossible to do sql queries.
I know that utf works in mysql because:
mysql> SHOW VARIABLES LIKE "character_set_%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ |
I apologize for the long message.
Any ideas on where to look next ?
Thank you,
Stelios _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? =http://www.otrs.de/
participants (3)
-
Alexander Scholler -
Maistros Stelios -
Nils Breunese (Lemonbit Internet)