MySQL 4.1.10 and utf8

MySQL 4.1.10 and utf8

am 27.06.2005 12:04:46 von Birgit Kellner

Hello,

I updated a linux box from MySQL 4.1.5 to 4.1.10, using the SuSE 9.3 rpms.
The databases, tables and columns had all been set to utf8 already before the
update, using the collation utf8_general_ci.

Since the update, utf8 data gets displayed and handled properly with php5
(through phpMyAdmin), but not with perl (5.8.6) scripts - neither from the
command line, nor from a browser interface. I therefore suspect that
something in the communication between perl and MySQL is wrong.

I am not well-versed in these technical matters, so please excuse anything
newbieesque in my approach, and do not hesitate to point me to more adequate
forums where I might get help with this problem.

The steps I have undertaken thus far are:
- make sure that utf8 is the default-character-set in MySQL (the output of
"show variables like 'char%'" confirms that utf8 is the value in all rows)
- update DBD-mysql (2.9008)
- apply utf8-patch to DBD-mysql (http://lists.mysql.com/perl/3563)
- make sure that utf8 is the default character set in the Apache2 config file
(seemed to be necessary in the setup I had before the update)

LC_CTYPE is set to "de.DE.UTF-8".

What puzzles me is that, with 4.1.5, all perl applications worked fine with
utf8 data in the database; it's only since the update that things went wrong,
and they only go wrong with perl.

Any help would be greatly appreciated,

best regards,

Birgit Kellner

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: MySQL 4.1.10 and utf8

am 27.06.2005 12:36:23 von Jan Kratochvil

Hi,

On Mon, 27 Jun 2005 19:04:46 +0900, birgit.kellner@univie.ac.at wrote:
....
> I updated a linux box from MySQL 4.1.5 to 4.1.10,

Not sure of 4.1.5, I went mostly 3.23.58->4.1.11.

....
> - apply utf8-patch to DBD-mysql (http://lists.mysql.com/perl/3563)

Be sure to also enable this patch:
DBI->connect(...,
"mysql_enable_utf8"=>1,
);

....
> LC_CTYPE is set to "de.DE.UTF-8".

And use testing client like
mysql --default-character-set=utf8 ...
and/or /etc/my.cnf:
[mysql]
default-character-set=utf8


HTH,
Lace

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: MySQL 4.1.10 and utf8

am 27.06.2005 13:21:03 von Birgit Kellner

Am Montag, 27. Juni 2005 12:36 schrieb Jan Kratochvil:

> > - apply utf8-patch to DBD-mysql (http://lists.mysql.com/perl/3563)
>
> Be sure to also enable this patch:
> DBI->connect(...,
> "mysql_enable_utf8"=>1,
> );
>
> ...

Thank you! This seems to have solved the problem.

In a web application, I still have some utf8 display issues, but these seem to
be limited to data that is printed via Template::Toolkit, and they do not
always occur, so I guess that the main problem is solved.

Best regards,

Birgit

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org