Hello everyone!
Below you can find the problem I'm dealing with.
I'd appreciate your help.
Thank you!!
- A description of what you are trying to achieve and what results you expect.:
I'd like to execute a query using the underscore as a pattern.
select id,etiqueta from limites_municipales where etiqueta like 'Garaf_a';
It should return some rows but it is not:
id | etiqueta
----+----------
(0 rows)
This is the content in the table:
palma=> select id,etiqueta from limites_municipales;
id | etiqueta
-------+--------------------------
0 | El Paso
12743 | Tazacorte
12744 | Los Llanos de Aridane
12745 | Villa de Mazo
12746 | Breña Baja
12747 | Santa Cruz de la Palma
12748 | Garafía
12749 | San Andrés y Sauces
12751 | Puntallana
12741 | Puntagorda
12742 | Tijarafe
12975 | Breña Alta
12976 | Fuencaliente de la Palma
12837 |
12846 |
.....
12910 |
12750 | Barlovento
(38 rows)
- PostgreSQL version number you are running:
PostgreSQL 8.4.1 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-10), 64-bit
- How you installed PostgreSQL:
Downloaded from postgresql.org and installed.
- Changes made to the settings in the postgresql.conf file:
no changes.
- Operating system and version:
Linux centos
- What program you're using to connect to PostgreSQL:
psql
- Is there anything relevant or unusual in the PostgreSQL server logs?:
No
- For questions about any kind of error:
Does the behaviour has to do with the client_encoding or server_encoding of the cluster?
Both are set to SQL_ASCII.
The locale list in the server is:
LANG=es_ES.ISO-8859-15
LC_CTYPE="es_ES"
LC_NUMERIC="es_ES"
LC_TIME="es_ES"
LC_COLLATE="es_ES"
LC_MONETARY="es_ES"
LC_MESSAGES="es_ES"
LC_PAPER="es_ES"
LC_NAME="es_ES"
LC_ADDRESS="es_ES"
LC_TELEPHONE="es_ES"
LC_MEASUREMENT="es_ES"
LC_IDENTIFICATION="es_ES"
LC_ALL=es_ES
