Message-ID: <00c501bf3d9c$e1875b00$c85204d5@pep>
From: "Oscar Serrano" <oserra@fondos.net>
To: <pgsql-interfaces@postgreSQL.org>
References: <199911280627.BAA13538@lee.k12.nc.us>
	<002801bf3a6b$68d27d40$701d04d5@pep>
	<19991130112714.A375@fam-meskes.de>
Subject: RE: [INTERFACES] Spanish format on date and numbers
Date: Fri, 3 Dec 1999 15:44:01 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


----- 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!
>
> ************
>
>
>
> ************
>