Hi Stelios,
OTRS doesn't actually support UTF-8 "100% correct", meaning that OTRS
stores UTF-8-characters double-encoded in the MySQL-DB.
This is described several bug reports and also in the mailing lists
(don't know if german or english, month 11/2005 to 02/2006??)
In my opinion, you can setup OTRS to use UTF-8 (especially if you have
the need like you) but you must do some fixing:
* very important, set the right character set on DB-connection
http://bugs.otrs.org/show_bug.cgi?id=1035
* implement an attachement-bugfix when you use filesystem-article-storage
Bye, Alex
Maistros Stelios schrieb:
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/
_______________________________________________
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/
