Share To My Love x--)

[Adam Wilson]

Dear:
I would like to share with you my recently shopping experience: I
found a very excellent e-site, the above is the latest and most
popular products. By their staff, understanding that they have stable
supply channel, so the price of products is shock your eyeballs burst.
Certainly I will not miss this opportunity, I received my ordered
products 5 days later.
If you are free, I suggest you can go to see:difsiz.com j--)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Hex data in VARBINARY fields -- Is it me, or MySQL?

[Adam Wilson]

OK so...
I'm having this problem where I'm trying to store (rather small
(36-byte)) hex values in MySQL, but some of them end up getting
truncated, therefore breaking my app... I'm using 4.1.10, with
--default-table-type=InnoDB... Or what ever option that is
anyway... point is, all of these tables are InnoDB...

Here's the problem..



mysql CREATE TABLE `table` (`field` VARBINARY(36) DEFAULT NULL);
Query OK, 0 rows affected (0.01 sec)

mysql INSERT INTO `table` SET field =
0xdee96318a69c8ba3208e1b2e91233725f5bb99a4708df7ad367c7285041bbb17652a0f20;
Query OK, 1 row affected (0.00 sec)

mysql SELECT HEX(`field`) FROM `table` WHERE `field` =
0xdee96318a69c8ba3208e1b2e91233725f5bb99a4708df7ad367c7285041bbb17652a0f20;
Empty set (0.00 sec)

mysql SELECT HEX(`field`) FROM `table`;
++
| HEX(`field`)   |
++
| DEE96318A69C8BA3208E1B2E91233725F5BB99A4708DF7AD367C7285041BBB17652A0F |
++
1 row in set (0.00 sec)

mysql SELECT HEX(`field`) FROM `table` WHERE `field` =
0xdee96318a69c8ba3208e1b2e91233725f5bb99a4708df7ad367c7285041bbb17652a0f;
++
| HEX(`field`)   |
++
| DEE96318A69C8BA3208E1B2E91233725F5BB99A4708DF7AD367C7285041BBB17652A0F |
++
1 row in set (0.00 sec)



AND... to make things worse I have a unique index on the column,
so it breaks even more



mysql CREATE UNIQUE INDEX `index` ON `table` (`field`);
Query OK, 1 row affected (0.02 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql INSERT INTO `table` SET field =
0xdee96318a69c8ba3208e1b2e91233725f5bb99a4708df7ad367c7285041bbb17652a0f20;
ERROR 1062 (23000): Duplicate entry '??c ?#7%p???6|r?e*' for key 1



I'd appreciate any Ideas anyone has any ideas/suggestions... I'd hate
to unnecessarily submit a bug report, if it's something on my end.


THANKS!!!

--Adam

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]