Greetings. I have Text fields in some tables which contain text in Portuguese with accent characters like á, à, é, í, ú, ü, ó, ö, ç, etc.
When I query like: SELECT text_column FROM table WHERE text_column LIKE %maçã% [ or ] WHERE text_column LIKE %ç%ã% it also returns 'maca', 'maça', etc, which are different words. How can I restrict results to accent characters/words? Must I use the '=' operator instead of 'LIKE'? In that case I suppose I do not get results for similar words. Adding a FULLTEXT to those text fields would solve it? The charset on all the tables is latin1, using Mysql 5. Thanks in advance. Pedro. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]