encoding problem

From: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: encoding problem
Date: 2005-12-01 14:46:43
Message-ID: 20051201144643.59071.qmail@web35614.mail.mud.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Winter 2005-12-01 14:47:35 Re: How to run a stored PL/pgSQL function?
Previous Message Richard Huxton 2005-12-01 14:18:51 Re: help with utf8