Hello again Nils / all, It seems that I can get the greek chars to work by installing mysql 5.x from source specifying all the character sets. .. ./configure --prefix=/usr/local/mysql --with-extra-charsets=all ..
I will have to nail down the specific set when I have time.. I also removed the references that were specifying character sets in the /etc/my.cnf file I then recreated the otrs db w/o using any character set option Finally, I made sure that iso-8859-7 is entered in /etc/httpd/conf/httpd.con .. AddDefaultCharset iso-8859-7 .. And In /opt/otrs/Kernel/Config.pm ... $Self->{'DefaultCharset'} = 'iso-8859-7'; .. So far, so good...If anyone has run into similar problems please let me/everyone know. Stelios -----Original Message----- From: Maistros Stelios Sent: Tuesday, March 14, 2006 4:33 PM To: 'otrs@otrs.org' Subject: RE: Problem storing UTF greek chars in mysql using otrs 2.0.4 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 _______________________________________________ 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/