Hello everyone!
My problem is to force otrs to work with utf8 - i can not do that but
maybe i just don't
understand something and there is a easy solution for me?
OS: debian GNU/Linux (etch) (all versions data below are from dpkg - the
debian
package manager)
otrs: 2.0.4p01-18
mysql: 5.0.32-7etch6
perl: 5.8.8-7etch3
I create database manualny (with "character set utf8") and import all
data as
wrote in README.database (plus i made change in my.cnf adding
"default-character-set = utf8" for client and server sections)
- the command "show variables like 'character_set_%';" typed in mysql shell
shows:
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)
Next i've add "$Self->{'DefaultCharset'} = 'utf-8';" to the
/etc/otrs/Kernel/Config.pm
(the admin panel: sysconfig::frontend::core (in otrs) shows 'utf-8' as
default character set)
Now i import some user data from other database to the `customer_user`
table
(name/surname/email/login) - those data are stored in utf8 and there is
no problem
with mysql server - import work exelent and table `customer_user`
contain data in utf8.
But when i try to listed customers in otrs (via 'customers' menu ) i
have '?' in
place of polish (i'm polish) diacritic characters. When i try to add new
customer with
some polish diacritic chars in the name i see it properly in otrs but
there are /strange/
characters in mysql table (so the otrs did not write it in utf8 i
think). i'm using Apache
server if it has any meaning and webpage encoding in my browser is ok -
it is utf8.
Has anyone any suggestion how to see the `customers_user` table data
(that are in utf8)
in otrs with properly utf8 encoding?
regards
Lukasz
_______________________________________________
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
