On Mon, 2 Jun 2014 13:19:56 -0400, Greg Sabino Mullane
<[email protected]> wrote:
> Version 3.3.0 of DBD::Pg, DBI driver for PostgreSQL, is
> now available. This release enhances UTF-8 support a
> great deal, thanks to the work of Dagfinn Ilmari Mannsåker
> and Nicholas Clark. As always, you can find it on CPAN at:
I am unsure yet if I see this new UTF8 support as improvement for the
general public. An example:
--8<--- dbd-pg3.pl
#!/pro/bin/perl
use 5.18.2;
use warnings;
use DBI;
my $dbh = DBI->connect ("dbi:Pg:");
$dbh->{AutoCommit} = 1;
say "Connected with DBI-$DBI::VERSION using DBD::Pg-$DBD::Pg::VERSION (",
$dbh->{pg_lib_version}, " -> ", $dbh->{pg_server_version}, ")";
$dbh->do ("create temp table hash (c_hash bytea primary key, v_hash bytea)");
my $stt = $dbh->prepare ("select * from hash");
$stt->execute;
my @typ = @{$stt->{TYPE}};
$stt->finish;
my $sth = $dbh->prepare ("insert into hash values (?, ?)");
$sth->bind_param (1, undef, $typ[0]);
$sth->bind_param (2, undef, $typ[1]);
say "c_hash $typ[0]\nv_hash $typ[1]";
$sth->execute ("key", "value");
$sth->execute ("eur", "\x{20ac}");
$sth->finish;
$dbh->do ("drop table hash");
$dbh->disconnect;
-->8---
Connected with DBI-1.631 using DBD::Pg-2.18.1 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-2.19.0 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-2.19.1 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-2.19.2 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-2.19.3 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.0.0 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.1.0 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.1.1 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.2.0 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.2.1 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.3.0 (90304 -> 90304)
c_hash -3
v_hash -3
Wide character in subroutine entry at /home/merijn/dbd-pg3.pl line 27.
Exit 255
That does *not* make me happy
> http://search.cpan.org/dist/DBD-Pg/
>
> Checksums:
>
> 547de1382a47d66872912fe64282ff55 DBD-Pg-3.3.0.tar.gz
> 9ec52d0d75463e6a448760e2d2fcbc41ca6201e1 DBD-Pg-3.3.0.tar.gz
>
> Complete list of changes:
>
> Version 3.3.0 Released May 31, 2014 (git commit
> 055f788cf96b380b9fe0e80b6cedb88f8d1799b8)
>
> - Major cleanup of UTF-8 support:
> Fix quoting of UTF-8 values
> Add support for UTF-8 statement strings
> Fix UTF-8 support in placeholders and return values
> [Dagfinn Ilmari Mannsåker] (CPAN bug #95214 and #91655)
> Test that the Pg server agrees with us about the lengths of input
> strings.
> Refactor Unicode test to use anon hashes to describe the tests to run.
> Test pg_enable_utf8 of -1, in addition to 0 and 1.
> Extend the Unicode round-trip tests to verify ASCII, BMP and non-BMP
> code points.
> Test that characters created in the server reach the client correctly.
>
> - Rewrite foreign_key_info to be just one query
> [Dagfinn Ilmari Mannsåker]
>
> - Remove ODBC support from foreign_key_info
> [Dagfinn Ilmari Mannsåker]
>
> - Remove use of dTHX in functions in quote.c and types.c
> [Nicholas Clark]
--
H.Merijn Brand [email protected] (072) 567 13 51
PROCURA B.V. http://www.procura.nl KvK 37140650
Ban de e-mail disclaimers: http://tinyurl.com/kmne65
