In the process of converting over to 3.23.30-gamma from 3.22
whenever I set the field to a binary field to a value it stores it in
the database as zero.
Does anyone have any suggestions.
I am having a problem with the binary data type... Here is the log to
demonstrate.
---------------------------------------------------------
mysql> create table crud (bin varchar(16) binary);
Query OK, 0 rows affected (0.02 sec)
mysql> insert into crud (bin) values (0x1);
Query OK, 1 row affected (0.00 sec)
mysql> insert into crud (bin) values (0x2);
Query OK, 1 row affected (0.00 sec)
mysql> select * from crud where bin=0;
+------+
| bin |
+------+
| |
| |
+------+
2 rows in set (0.00 sec)
mysql> select * from crud where bin=0x0;
+------+
| bin |
+------+
| |
| |
+------+
2 rows in set (0.00 sec)
mysql> select * from crud where bin=0x1;
Empty set (0.00 sec)
mysql> select * from crud where bin=0x2;
Empty set (0.00 sec)
----------------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php