Oscar Serrano wrote:
> 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?
Vague memory tells me it's ISO8859-2. I use LC_CTYPE=iso_8859_1, as in my
/usr/share/locale directory (this is under NetBSD) I have
% ls /usr/share/locale
de es iso_8859_1 nl pl sl
el fr ko no ru sv
% ls /usr/share/locale/iso_8859_1
I don't know where I would find nor how to write an appropriate LC_CTYPE
file - never needed to, and never tried --enable-locale - I just set LC_CTYPE
for nice keyboard sequences.
> 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.
There's only one way to find out!
In response to
pgsql-interfaces by date
|Next:||From: Oscar Serrano||Date: 1999-11-27 20:44:44|
|Subject: datetime, JDBC, and MS Access|
|Previous:||From: Tom Lane||Date: 1999-11-27 05:36:41|
|Subject: Re: [INTERFACES] Slow join query optimisation? |