|Subject:||utf8 and mysql_auto_reconnect|
DBD::mysql has a bug when reading utf8 data from a MySQL database and "mysql_auto_reconnect" is enabled. First you have to set the character set for the connection to get the results in the correct encoding: $dbh->do("set names utf8"); Then you read data from the database--->everything is okay. When a reconnect occurs the driver forgets about the connection encoding and the results are delivered with the default encoding (e.g. 'latin1').