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