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]
