Hmmm, strange...
From the mysql client I see:
mysql> show variables like "%char%";
+--------------------------+-------------------------------------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------------------------------------+
| character_set_client | latin2 |
| character_set_connection | latin2 |
| character_set_database | latin2 |
| character_set_results | latin2 |
| character_set_server | latin2 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql-standard-4.1.9-pc-linux-gnu-i686/share/mysql/charsets/ |
+--------------------------+-------------------------------------------------------------------------+
But from DBI I get:
my $sth = $dbh->prepare('SHOW VARIABLES like "%char%"');
$sth->execute;
print Dumper($sth->fetchall_arrayref({}));$VAR1 = [
{
'Value' => 'latin1',
'Variable_name' => 'character_set_client'
},
{
'Value' => 'latin1',
'Variable_name' => 'character_set_connection'
},
{
'Value' => 'latin2',
'Variable_name' => 'character_set_database'
},
{
'Value' => 'latin1',
'Variable_name' => 'character_set_results'
},
{
'Value' => 'latin2',
'Variable_name' => 'character_set_server'
},
{
'Value' => 'utf8',
'Variable_name' => 'character_set_system'
},
{
'Value' =>
'/usr/local/mysql-standard-4.1.9-pc-linux-gnu-i686/share/mysql/charsets/',
'Variable_name' => 'character_sets_dir'
}
];Looks like if the client is DBD then I get different character encodings... wow! I wonder how can I tell DBI/DBD or MySQL not to do that... :-(
- Cs.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
