Re: [DBD::Pg 2/2] Commit UTF-8 design notes/discussion betweenDWC/GSM
"David E. Wheeler" <[email protected]> Thu, 21 Jul 2011 17:19:03 -0700
| Newsgroups | gmane.comp.db.postgresql.dbdpg |
|---|---|
| Message-ID | <[email protected]> |
On Jul 21, 2011, at 5:06 PM, [email protected] wrote: > I point out that Pg itself supports Perl for stored procedures in PL/Perl. > What if I have a perl program which wants to store a perl procedure to the database? I have not done such a thing myself I use stored procedures very seldom but I could see interesting possibilities This issue was fixed in 9.0 in PL/Perl. This is the relevant release note: • Verify that PL/Perl return values are valid in the server encoding (Andrew Dunstan) What this means is that it's up to you to return data from Perl in the server encoding, IIRC. If the server encoding is UTF-8, then IIRC things should just work. Would be nice to see this spelled out in the docs somewhere, though. Think I'll bug Andrew about that. Best, David