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
I'm not an expert, but I think that OTRS code should do something like this: 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
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
participants (1)
-
magicboiz