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/
