encoding problem

[marcelo Cortez <jmdc_marcelo@xxxxxxxxxxxx>]

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