Searching accented words

Поиск
Список
Период
Сортировка
От João Paulo Batistella
Тема Searching accented words
Дата
Msg-id 20020724192010.26238.qmail@web21206.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Searching accented words
Re: Searching accented words
Re: Searching accented words
Re: Searching accented words
Список pgsql-general
Hi!

I have, in the same column, accented words and not.
But I don´t want to worry about it.

Imagine the table Person:
CREATE TABLE PERSON (name TEXT)

INSERT INTO PERSON VALUES ('José')
INSERT INTO PERSON VALUES ('Jose')

The following statement
SELECT * FROM PERSON WHERE NAME like 'José'
would return only the first row, because 'José' is an
accented word.

How can I perform a query that return the two rows, no
matter I pass 'José' or 'Jose' as parameter?

Thanks,
JP

_______________________________________________________________________
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

В списке pgsql-general по дате отправления: