Hi Vincent
On 07/04/14 22:03, Vincent Veyron wrote:
On Mon, 07 Apr 2014 20:10:31 +1000
Ron Savage <r...@savage.net.au> 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
