Hello Nils, I just set it up and the result is the same. So far, I have tried putty, secure shell and the system console with the same results. It makes me think that the problem is on the mysql side or possibly in the way otrs stores data, but do not know where else to look. Stelios //// Nils Breunese 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. -----Original Message----- From: Maistros Stelios Sent: Tuesday, March 14, 2006 2:11 PM To: 'otrs@otrs.org' Subject: 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