From: Oscar Serrano <oserra@fondos.net>
To: pgsql-interfaces@postgreSQL.org
Subject: RE: [INTERFACES] Spanish format on date and numbers
Date: Fri, 26 Nov 1999 20:29:21 +0100
Message-ID: <006e01bf3844$8c693560$0778ebc3@pep> (raw)
References: <E11rQbO-0002Fh-00@quartz.newn.cam.ac.uk>
----- Original Message -----
From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: Oscar Serrano <oserra@fondos.net>
Cc: <pgsql-interfaces@postgreSQL.org>
Sent: Friday, November 26, 1999 8:00 PM
Subject: Re: [INTERFACES] Spanish format on date and numbers
> Oscar Serrano wrote:
> >
> > I'm from Spain. I've exported some tables from MS Access to Postgres.
You
> > know, in Spain, a number like this: 1,234.56 me write it like this:
1.234,56
> > i.e., the thousand separator is the "." and the decimal separator is the
","
>
> I have never tried, but when building postgresql from source,
> configure --enable-locale
> might be the answer? (cf. Oleg's page
http://www.sai.msu.su/~megera/postgres/)
>
> Cheers,
>
Hi again :-)
Reading some web sites, it seems that, yes, I must use the --enable-locale
at configuration time.
And it seems that I must first define and export the variables LANG, LC_ALL,
LC_CTYPE (and probably LC_COLLATE).
The LANG variable seems to must be: LANG="es_ES", for spanish configuration.
The LC_CTYPE must be something like this: LC_CTYPE="ISO8859-1". But, what is
the ISO for spain?
So, if I define this variables and use the --enable-locale, the psql will
return the numbers and dates in the spanish format?
I can't believe it.
Where are the files that defines how is the spanish format? You know, I'm
installing postgres in a ISP in USA, so very probably, the dedicated server
where I'm installing it, hasn't this files. I think I will need to modify
them, or to upload the spanish definition files.
Thank you very much.
> Patrick
>
> ************
>
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: <006e01bf3844$8c693560$0778ebc3@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