| From: | João Paulo Batistella <batistellabr(at)yahoo(dot)com(dot)br> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Searching accented words |
| Date: | 2002-07-24 19:20:10 |
| Message-ID: | 20020724192010.26238.qmail@web21206.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Wollny | 2002-07-24 19:20:34 | Re: Using FTI-Search (likely a more general runtime-puzzle) |
| Previous Message | Jan Wieck | 2002-07-24 18:56:00 | Re: Data Corruptions (How to delete a corrupted row?) |