> But when I do a select for specifcly word like sao, I get all the three !!! > > Internally MySQL isn't distinguing the different words, assuming that à = A, > and O = Ã. >
I don't think MySQL has a Portuguese collation yet. You could try one of the other collations to see if its compatible with Portuguese. For instance: SELECT word FROM dictionary WHERE word = 'SA0' COLLATE latin1_spanish_ci; To see the collations available for your character set (latin1) type: SHOW COLLATION LIKE 'latin1%'; You could also try latin1_bin, but it would not be case insensitive. If these solutions aren't satisfactory you could try to write a Portuguese collation. Its not very hard and you could submit it to MySQL to include in their official distribution. See the documentation here: http://www.mysql.com/doc/en/Adding_character_set.html and here: http://www.mysql.com/doc/en/Charset.html I've done some work on a complex character set. Mine isn't quite finished, but Portuguese would probably be a simple one (see the docs for the difference between simple and complex charsets). I've learned enough that I could probably help you out with the Portuguese one if you need it. Good luck, Jeremy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
