Re: Database encoding not recognized by DBD::Pg

Hi Vincent

On 07/04/14 22:03, Vincent Veyron wrote:
> On Mon, 07 Apr 2014 20:10:31 +1000
> Ron Savage <[email protected]> wrote:
>
>>
>> Of course, but I tested Unicode characters which are not ASCII, OK?
>>
>
> duh! sorry about that, I should have known better. It's been a long week...
>
> Note that the server with the fr_FR:fr encoding is the one that displays characters correctly, as in your tests. It's the one with only fr_FR@euro that doesn't (on a cluster that was initialized with LATIN9; mixed encodings work fine on a UTF-8 default cluster).
>
> I don't quite grasp locales related matters in Debian. I tried adding it manually in /etc/default/locale on the faulty server, running dpkg-reconfigure afterwards, but to no avail.

AFAICT locales have no effect on my code.

I do have a policy of creating databases with:

create database $name owner $role encoding 'UTF8';

See also:

http://savage.net.au/Perl/dbd.utf8.pl

-- 
Ron Savage
savage.net.au