Re^7: UTF8 issue when getting website via LWP::UserAgent in Perl

[ultranerds]

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

[runrig]

Did you know you're not checking the status of the connect or the prepare? And if you turn on RaiseError in the connect, you'll automatically check all DBI methods, and you won't even need the 'or die' on the execute.

[ultranerds]

That was just a very quick example I put together, to test the theory about how the data ended up in the table :)