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@xxxxxxxxx> escribió: > marcelo Cortez <jmdc_marcelo@xxxxxxxxxxxx> 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@xxxxxxxxx> > > ---------------------------(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