Re: encoding bug or feature? - Mailing list pgsql-general

From marcelo Cortez
Subject Re: encoding bug or feature?
Date
Msg-id 20060710191022.86410.qmail@web32105.mail.mud.yahoo.com
Whole thread Raw
In response to Re: encoding bug or feature?  (Jorge Godoy <jgodoy@gmail.com>)
Responses Re: encoding bug or feature?  (Jorge Godoy <jgodoy@gmail.com>)
List pgsql-general
Jorge


 the postgreslq.conf say


lc_messages = 'es_AR'                   # locale for
system error message
                                        # strings
lc_monetary = 'es_AR'                   # locale for
monetary formatting
lc_numeric = 'es_AR'                    # locale for
number formatting
lc_time = 'es_AR'                               #
locale for time formatting

but the upper function fail for me.
what is your settings?
BTW the database is SQL_ASCII

any pointer be appreciated
 best regards

  MDC



 --- Jorge Godoy <jgodoy@gmail.com> escribió:

> marcelo Cortez <jmdc_marcelo@yahoo.com.ar> writes:
>
> > folks
> >
> >
> >  select ucase( 'ñ'); -> 'ñ'
> >  i want this statemen return  'Ñ'
> >  any ideas?
>
> test=# select upper( 'ñ');
>  upper
> -------
>  Ñ
> (1 record)
>
> test=#
>
>
> Maybe your locale settings are wrong...
>
> --
> Jorge Godoy      <jgodoy@gmail.com>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>






___________________________________________________________
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar


pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: US Telephone Number Type
Next
From: Mark Morgan Lloyd
Date:
Subject: Re: Procedural language functions across servers