in reply to Re: Perl and Postgresql: Invalid byte sequence for encoding "UTF8"
in thread Perl and Postgresql: Invalid byte sequence for encoding "UTF8"

Remarkable, thanks!

I had tried using Encode before, but missed the "UTF-8" bit apparently. It's working perfectly now.

  • Comment on Re^2: Perl and Postgresql: Invalid byte sequence for encoding "UTF8"

Replies are listed 'Best First'.
Re^3: Perl and Postgresql: Invalid byte sequence for encoding "UTF8"
by Anonymous Monk on Jun 17, 2009 at 12:04 UTC
    It is NOT the capitalization that is needed. Encode is case-insensitive for the encoding. It is the hyphen that makes the difference, see this example:
    use Encode qw(resolve_alias); my @aliases = ('utf-8', 'UTF-8', 'utf8',); for my $alias ( @aliases ) { my $canonical_name = Encode::resolve_alias($alias); print "$alias \t has canonical name $canonical_name\n"; }