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