It worked !!! I used the latin1_bin collation.
Thanks! SLepetys ----- Original Message ----- From: "Jeremy March" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 07, 2004 12:14 AM Subject: COLLATION > > 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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
