Re: name 'Szczech' returns more rows then 'Szczec%'

[Jake Peavy]

On 6/1/06, Lukasz Budnik <[EMAIL PROTECTED]> wrote:

name column is:

  `name` varchar(50) NOT NULL default 'NN'

and table is DEFAULT CHARSET='latin2' but as I wrote before
all those names have only latin1 characters

I am not able to reproduce it on 5.0.16 on WinXP.

mysql> DROP TABLE IF EXISTS `lbudnik-test`;
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLE `lbudnik-test` (
   ->  `id` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
   ->  `name` VARCHAR(50) NOT NULL default 'NN',
   ->  PRIMARY KEY (id)
   -> ) ENGINE=MyISAM DEFAULT CHARSET=latin2;
Query OK, 0 rows affected (0.10 sec)

mysql> INSERT INTO
   ->  `lbudnik-test`
   -> VALUES
   ->  (NULL,'Szczechura'),
   ->  (NULL,'Szczechowiak'),
   ->  (NULL,'Szczechowski'),
   ->  (NULL,'Szczech'),
   ->  (NULL,'Szczech'),
   ->  (NULL,'Szczeb'),
   ->  (NULL,'Szczec');
Query OK, 7 rows affected (0.00 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql> SELECT id, name FROM `lbudnik-test` WHERE name LIKE 'Szczec%';
+----+--------------+
| id | name         |
+----+--------------+
|  1 | Szczechura   |
|  2 | Szczechowiak |
|  3 | Szczechowski |
|  4 | Szczech      |
|  5 | Szczech      |
|  7 | Szczec       |
+----+--------------+
6 rows in set (0.00 sec)

mysql> SELECT id, name FROM `lbudnik-test` WHERE name LIKE 'Szczech';
+----+---------+
| id | name    |
+----+---------+
|  4 | Szczech |
|  5 | Szczech |
+----+---------+
2 rows in set (0.00 sec)

mysql> SELECT id, name FROM `lbudnik-test` WHERE name = 'Szczech';
+----+---------+
| id | name    |
+----+---------+
|  4 | Szczech |
|  5 | Szczech |
+----+---------+
2 rows in set (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.0.16-nt |
+-----------+
1 row in set (0.00 sec)

--
-jp


If you can see Chuck Norris, he can see you. If you can't see Chuck Norris
you may be only seconds away from death.