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 по дате отправления: