http://qs1969.pair.com?node_id=1162876


in reply to Re^6: UTF8 issue when getting website via LWP::UserAgent in Perl
in thread UTF8 issue when getting website via LWP::UserAgent in Perl

Thanks for the info. Man, this is a PITA :S Think I may have to take a break, and come back to it tomorrow.

There is definitely something up - because even using basic DBI connection, it still messes it up:

my $dsn = "DBI:mysql:database=$db_cfg->{database};host=$db_cfg->{h +ost};port=3307"; my $dbh = DBI->connect($dsn, $db_cfg->{login}, $db_cfg->{password} +); $dbh->{mysql_enable_utf8} = 1; my $sth = $dbh->prepare( "INSERT INTO ReadingGrabCache SET title = + ?" ); $sth->execute( $title ) or die $DBI::errstr;
Eugh :/