Re: Database encoding not recognized by DBD::Pg

Hi Vincent

I ran a few tests, using:

cat /etc/default/locale
#  File generated by update-locale
LANG="en_AU.UTF-8"
LANGUAGE="en_AU:en"

No problems showed up.

On 07/04/14 03:59, Vincent Veyron wrote:
> On Sun,  6 Apr 2014 16:01:54 -0000
> "Greg Sabino Mullane" <[email protected]> wrote:
>
>>
>> What are server_encoding and client_encoding set to on each database?
>>
>
> Hi Greg,
>
> Same thing for both servers:
>
> ppro_utf8=> show client_encoding;
>   client_encoding
> -----------------
>   LATIN9
> (1 ligne)
>
> ppro_utf8=> show server_encoding;
>   server_encoding
> -----------------
>   UTF8
> (1 ligne)
>
>
> I suspect something to do with locales on Debian? The good server (primary) is an OVH hosted machine, which runs a debian version that they customize, while the bad one (backup) was built using stock debian net-install. I found a difference in the LANGUAGE environnement variable (with that strange fr_FR:fr), other than that all configuration files are identical on both machines.
>
> cat /etc/default/locale
> #Primary
> LANG=fr_FR@euro
> LANGUAGE=fr_FR:fr
>
> #Backup
> LANG=fr_FR@euro
>

-- 
Ron Savage
savage.net.au