Hello,
I upgraded my otrs installation from version 2.0.4 to version 2.2.3.
I run the proper scripts to update the db schema but after the scripts
completed without any errors I have encountered a problem with the db
collation.
Specifically, any information that was entered in Greek is not displayed
properly.
I am using mysql5, perl 5.8.8 on Fedora 5
In the /otrs/Kernel/Config.pm I have the line
$Self->{'DefaultCharset'} = 'utf-8';
And in
In the /otrs/Kernel/Language/en.pm I have the line
$Self->{Charset} = ['us-ascii', 'UTF-8', 'iso-8859-1', 'iso-8859-7'];
(iso-8859-7 is the greek char set)
but it does not seem to make a difference - the tickets are there but
the encoding is not working properly.
Afterwards I also did the following:
In /opt/otrs/scripts/tools I noticed the scripts
-rwxrwxr-x 1 apache apache 2288 Sep 13 10:14 charset-convert.pl
-rw-rw-r-- 1 apache apache 3504 Sep 13 10:14 convert_db_to_utf8.pl
I tried them, first by converting the db dump by doing
# charset-convert.pl -s <latin1> -d <utf8> -f dump.sql
And the then loading back the converted dump into mysql.
My tickets are all there, but the encoding on the greek text is a mess
Any ideas anyone ?
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 or consulting for your OTRS system?
=> http://www.otrs.com/
