Mauricio, I believe in latin1, MySQL indeed identifies n-tilde with n.
Please test with the UTF-8 charset. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Mauricio Pellegrini" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, September 11, 2004 6:05 PM Subject: Wrong query result > Sorry to insist with this, but still can't find the reason. > > Any ideas? > > -----Forwarded Message----- > Hi, > I'm using MySql 4.1.4 Gamma and the following query returns > values containing N and Ñ instead of only those containing Ñ. > > The query is as follows > > Select Lastname from table1 where locate("Ñ",Lastname)>0 > > The result set includes values like this > > HERNANDEZ > NUÑES > MONTAGNE > MIÑO > ANTIÑACO > MORENO > GONZALEZ > > In other words mysql seems to mistake N with Ñ > > The charset for the tables is latin1 and the type InnoDB. > > What is happenning? > > > Mauricio > > > > > > -- > 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]
