Hi, Gabriel,
I tried the following from the "mysql" command line prompt:
mysql> insert into test (hash) values ('abcdefghiklmnopq');
Query OK, 1 row affected (0.00 sec)
mysql> insert into test (hash) values ('abcdefghiklmnop');
Query OK, 1 row affected (0.00 sec) mysql> insert into test (hash) values
('abcdefghiklmnop ');
ERROR 1062: Duplicate entry 'abcdefghiklmnop' for key 2
In other words: The database itself is cutting the trailing blank
from the command line, for whatever reason.
I would personally consider this a bug and would suggest that
you post your CREATE TABLE statement and the above statements
into the MySQL users mailing list. Please put me on the cc list.
Regards,
Jochen
