Re: encoding bug or feature?

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