I'm not an expert but I think OTRS code should do something like this: # Standard DBI connection. my $dbh = DBI->connect("DBI:mysql:${database}:${hostname}", $username, $password) or die "DB Connection not made: $DBI::errstr";
$dbh->{'mysql_enable_utf8'} = 1; $dbh->do('SET NAMES utf8'); On Miércoles 10 Febrero 2010 09:23:41 magicboiz escribió: > I don't understand....the client is the perl dbi interface used by otrs > code....... isn't it? > > look at this pls: > http://www.dev411.com/blog/2006/10/02/perl-mysql-and-utf-8 > > On Martes 09 Febrero 2010 23:40:34 Nils Leideck - ITSM escribió: > > HI, > > > > On 09.02.2010, at 07:45, magicboiz wrote: > > > | character_set_client | latin1 | > > > | character_set_connection | latin1 | > > > | character_set_database | utf8 | > > > | character_set_filesystem | binary | > > > | character_set_results | latin1 | > > > | character_set_server | latin1 | > > > | character_set_system | utf8 > > > > > > the client i use is this: > > > > > > otrs-server:~# mysql -h localhost -p > > > > you shold make sure that your MySQL connection is in utf-8 as well. > > This is for most systems the default when using MySQL Server 5.x > > Ask your DBMA or consult the MySQL Documentation please. > > You shold find most of the configuration in your my.cnf file ... mostly > > located in /etc/ or /etc/mysql/ > > > > Nils Leideck --------------------------------------------------------------------- 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/