2006/4/18, Pedro mpa <[EMAIL PROTECTED]>: > 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. >
Just change the collation ? or use binary : http://dev.mysql.com/doc/refman/4.1/en/charset-collations.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]