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/