encoding problem

folks

 i have problems with encodings
 the scenario is:

database: CREATE DATABASE "testLatin"
  WITH OWNER = owner1
       ENCODING = 'LATIN9';
test table:

CREATE TABLE test
( nombre varchar(20))
WITH OIDS;
ALTER TABLE test OWNER TO marcelo;
 data:
nombre
---------
"maricón"
"ñañoso pícaro"

test statement
select  * from test where upper(nombre) like 'ÑA%'
 not data found !!!

any ideas?
best regards

 MDC

pd: Unicode encoding  has same result.









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