Re: Database encoding not recognized by DBD::Pg
Vincent Veyron <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
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 -- Salutations, Vincent Veyron http://marica.fr/ Gestion des contentieux, des dossiers de sinistres assurance et des contrats pour le service juridique