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/