8 Sep
2004
8 Sep
'04
18:19
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