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 <[EMAIL PROTECTED]> escribió: > marcelo Cortez <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > > ---------------------------(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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster