Re: [SQL] underscore pattern in a query doens't work

2012-09-13 Thread Tom Lane
"Sergio C." writes: > We started the cluster up with this command: > ./initdb -D /usr/local/postgre/data -E UTF8 -U sir That doesn't prove anything about the specific database where you're having the problem ... regards, tom lane -- Sent via pgsql-sql mailing list (pgs

Re: [SQL] underscore pattern in a query doens't work

2012-09-13 Thread Sergio C.
info could I give you? De: Tom Lane Para: Sergio Calero. CC: "pgsql-sql@postgresql.org" Enviado: Jueves 13 de septiembre de 2012 16:19 Asunto: Re: [SQL] underscore pattern in a query doens't work "Sergio Calero." writes: > I

Re: [SQL] underscore pattern in a query doens't work

2012-09-13 Thread Tom Lane
"Sergio Calero." writes: > I'd like to execute a query using the underscore as a pattern. > select id,etiqueta from limites_municipales where etiqueta like 'Garaf_a'; > [ but this fails to match 'Garafía' ] I suspect what you have here is an encoding problem. That is, probably the "í" is represe