> Binary is an option on the varchar type
> I pulled the following quote from the mysql website.
>
> It just does not seem to be working anymore.
A guess:
It seems to me that the problem is not in
your colmn definition, but the silent type
conversions MySQL performs. In the log you
show below, you're trying to insert numerical
data into a column accepting strings. When
MySQL sees this, it tries to convert the hexadecimal
number, fails, and inserts a 0-length string.
When you query using SELECT, the 0x0 is semantically
equivalent to the empty string.
Have you tried explicitly converting the
numbers to strings (e.g. CONCAT(0x1) ) before
storing them?
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
>
> [NATIONAL] VARCHAR(M) [BINARY]
> A variable-length string. NOTE: Trailing spaces are removed when the
> value is stored (this differs from the ANSI SQL specification). The
> range of M is 1 to 255 characters. VARCHAR values are sorted and
> compared in case-insensitive fashion unless the BINARY keyword is given.
> See section 7.7.1 Silent Column Specification Changes. VARCHAR is a
> shorthand for CHARACTER VARYING. See section 7.3.4.1 The CHAR and
> VARCHAR Types.
>
> Rolf Hopkins wrote:
> >
> > I think you are a bit confused with binary and varchar.
> varchar is used to
> > store strings such as "the cow jumped over the moon" and binary
> means that
> > it is case sensitive.
> >
> > You are trying to insert a hex value of 0x1, right? I think this is an
> > illegal value and those two entries are set to NULL. MySQL behaves
> > differently from standard in that it inserts default values instead, if
> > there is an error, which in your case, would be NULL. What you
> want instead
> > is an integer column.
> >
> > ----- Original Message -----
> > From: "Tommie Jones" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, February 07, 2001 3:30
> > Subject: binary bug in mysql 3.23.30-gamma
> >
> > > 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
> >
> > ---------------------------------------------------------------------
> > 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
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
