[otrs] RE: Problem storing UTF greek chars in mysql using otrs 2.0.4 - SOLVED

15 Mar 2006

      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