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

14 Mar 2006

      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