Re: [otrs] Spanish Charset problems

2010-02-10 Thread magicboiz
I don't understandthe 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: |

Re: [otrs] Spanish Charset problems

2010-02-10 Thread magicboiz
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 understandthe client is the perl dbi interface used by otrs code... isn't it? look at this pls:

Re: [otrs] Spanish Charset problems

2010-02-10 Thread magicboiz
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');

Re: [otrs] Spanish Charset problems

2010-02-08 Thread Nils Leideck - ITSM
Hi, On 04.02.2010, at 19:17, magicboiz wrote: We have our OTRS configured with charset UTF-8. Apache 2.2.9. Mysql 5.0.51. Perl 5.10. Debian Lenny. make sure the Client connection is also fine! $# mysql mysql use otrs; mysql show variables search for non utf-8 settings in the output

Re: [otrs] Spanish Charset problems

2010-02-08 Thread magicboiz
Hi I get these values: | character_set_client| latin1 | | character_set_connection| latin1 | | character_set_database | utf8| | character_set_filesystem| binary | |

Re: [otrs] Spanish Charset problems

2010-02-05 Thread Ilya Kornev
Subject: [otrs] Spanish Charset problems Hello We have a ITSM::OTRS 1.3.2 running nicely, but we have a small problem that I hope someone can help me to solve: Spanish characters like Я, А, et, aren't displayed correctly into the otrs web frontend, and also into the emails formatted

[otrs] Spanish Charset problems

2010-02-04 Thread magicboiz
Hello We have a ITSM::OTRS 1.3.2 running nicely, but we have a small problem that I hope someone can help me to solve: Spanish characters like ñ, á, et, aren't displayed correctly into the otrs web frontend, and also into the emails formatted by otrs (From and To envelope addresses) We have