Gatrixx NetSolutions

Hello out there,

her is my problem:
I get some XML Data in utf8.
After I fetched the data I decode it from uft8 into latin1 like this:

use Unicode::String;

$utf_temp = Unicode::String::utf8($headline);
$headline = $utf_temp->latin1();

After this everything works fine. When I print the SQL query on STDOUT
it looks like this:
write(1, "INSERT INTO news
(ext_id,quelle_id,datum,headline) VALUES
(\'19971\',42,1120049280,\'Wiederanstieg auf den
Unterst\374tzungslinien\')

But when I send this query to the mysql server it looks like this:
write(7, "\227\0\0\0\3INSERT INTO news
(ext_id,quelle_id,datum,headline) VALUES
(\'19971\',42,1120049280,\'Wiederanstieg auf den
Unterst\303\274tzungslinien\')

In both cases it's just the same variable $query.

Can anybody help me out?

Regards, Neal

perl version v5.8.5
mysql server version: 4.1.11-max-log

--
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