Wrong query result ( Ñ - N )
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
9 Sep
9 Sep
11:17
New subject: [suse-linux-s] Wrong query result ( Ñ - N )
El 2004-09-08 a las 11:19 -0700, Mauricio Pellegrini escribió:
Hi, I'm using MySql 4.1.4 Gamma and the following query returns values containing N and Ñ instead of only those containing Ñ.
In spanish, please, you will get more results ;-) -- Saludos Carlos Robinson
7186
Age (days ago)
7187
Last active (days ago)
1 comments
2 participants
participants (2)
-
Carlos E. R.
-
Mauricio Pellegrini