From: Oscar Serrano <oserra@fondos.net>
To: pgsql-interfaces@postgreSQL.org
Subject: RE: [INTERFACES] Spanish format on date and numbers
Date: Fri, 3 Dec 1999 15:44:01 +0100
Message-ID: <00c501bf3d9c$e1875b00$c85204d5@pep> (raw)
References: <199911280627.BAA13538@lee.k12.nc.us>
<002801bf3a6b$68d27d40$701d04d5@pep>
<19991130112714.A375@fam-meskes.de>
----- Original Message -----
From: Michael Meskes <meskes@postgreSQL.org>
To: <pgsql-interfaces@postgreSQL.org>
Sent: Tuesday, November 30, 1999 11:27 AM
Subject: Re: [INTERFACES] Spanish format on date and numbers
> On Mon, Nov 29, 1999 at 02:12:15PM +0100, Oscar Serrano wrote:
> > As I told in previos messages, I thing I must compile Postgres
> > with --use-locale and have defined some variables. But I'm not sure how
to
> > define that variables, and in case I have them well defined, I don't
know if
> > it is needed extra configuration in my Linux, or have installed any
spanish
> > library or whatever.
>
> Does that mean a localized postmaster returns the number with ',' instead
of
> '.'? Mine certainly doesn't.
Well, I'm not sure. That's what I wanted to know. Reading the not very clear
documentation at this point, I understand that a spanish localiced
postmaster returns the the float numbers with ',' instead of '.'
I've seen that declaring don't-remember-what variable, the dates were
returned in the west-european format (dd/mm/aa).
Won't be a similar variable to the number format?
> In fact I remove LC_NUMERIC for ECPG to make sure numbers have the '.' as
> decimal seperator.
Reading the documentation of the installation process, I didn't see the
LC_NUMERIC variable anywhere. I only saw references to the LC_ALL, LC_CTYPE,
and LANG.
> Could anyone tell me what standard says? Is it "14.7" as my postmaster
gives
> it to me even with LC_ALL=de_DE and --use-locale or is it "14,7" as the
> German locale asks for (and I have a bug in my setup). If the later is
> correct ECPG has to go back to the drawing board.
The standard, I think, is "14.7" and not "14,7" if you don't use-locale.
Can anybody tell us what variables and how must they be defined before
compile with --use-locale to make the postmaster return values in the
spanish format?
Thanks.
> Michael
>
> --
> Michael Meskes | Go SF 49ers!
> Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
> Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
> Email: Michael@Fam-Meskes.De | Use PostgreSQL!
>
> ************
>
>
>
> ************
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: oserra@fondos.net
Subject: RE: [INTERFACES] Spanish format on date and numbers
In-Reply-To: <00c501bf3d9c$e1875b00$c85204d5@pep>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox