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 confuse 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]
