Hello everyone! I'm new to this group so I hope I don't begin with any faux pas.
I have a problem and don't seem to be able to make any headway with it. I have been using Arch Linux and Perl DBI/DBD for Postgresql quite happily now for years. My database contains German special characters and I have configured Arch Linux to use UTF-8. Everything was fine until Arch upgraded to DBD 3.0. DBI/DBD still worked well for INSERT statements, but the results of SELECT statements are now ISO-8859 8 bit characters. This has not changed after the release of DBD version 3.1. The simple work-around to the re-install the Arch package perl-dbd-pg-2.19.3-2-x86_64.pkg.tar.xz; that restores the correct behaviour. This is why I concluded that the problem probably lies with DBD and not DBI for Postgresql. In my select statements I even have explicitly: SET CLIENT_ENCODING TO 'UTF8'; I would be grateful for any pointers As a Kiwi in Germany I have a rather odd locale, namely: LANG=en_NZ.UTF-8 LC_CTYPE=en_NZ.UTF-8 LC_NUMERIC="en_NZ.UTF-8" LC_TIME=en_DK.UTF-8 LC_COLLATE="en_NZ.UTF-8" LC_MONETARY=en_IE.UTF-8 LC_MESSAGES="en_NZ.UTF-8" LC_PAPER="en_NZ.UTF-8" LC_NAME="en_NZ.UTF-8" LC_ADDRESS="en_NZ.UTF-8" LC_TELEPHONE="en_NZ.UTF-8" LC_MEASUREMENT="en_NZ.UTF-8" LC_IDENTIFICATION="en_NZ.UTF-8" LC_ALL= Yours, Mike Dowling -- Dr. Michael L. Dowling Gaußstr. 27 38106 Braunschweig Germany
