tinyblob vs varchar(255) binary

Hi,

I cannot see a real difference between ROWA and ROWB

CREATE TABLE THE_TABLE
(
ROWA varchar(255) binary NOT NULL default '',
ROWA tinyblob NOT NULL
)ENGINE=InnoDB, DEFAULT CHARSET=utf8;

As far as I can see they are both 255 chars binary, (one can have
default while the other cannot).
Are they not both the same?

FFMG


--

'webmaster forum' (http://www.httppoint.com) | 'Free Blogs'
(http://www.journalhome.com/) | 'webmaster Directory'
(http://www.webhostshunter.com/)
'Recreation Vehicle insurance'
(http://www.insurance-owl.com/other/car_rec.php) | 'Free URL
redirection service' (http://urlkick.com/)
------------------------------------------------------------------------
FFMG's Profile: http://www.httppoint.com/member.php?userid=580
View this thread: http://www.httppoint.com/showthread.php?t=21957

Message Posted via the webmaster forum http://www.httppoint.com, (Ad revenue sharing).

FFMG wrote:
> Hi,
>
> I cannot see a real difference between ROWA and ROWB
>
> CREATE TABLE THE_TABLE
> (
> ROWA varchar(255) binary NOT NULL default '',
> ROWA tinyblob NOT NULL
> )ENGINE=InnoDB, DEFAULT CHARSET=utf8;
>
> As far as I can see they are both 255 chars binary, (one can have
> default while the other cannot).
> Are they not both the same?
>
> FFMG

I can't even see a ROWB???

Paul Lautman;101906 Wrote:
>
> > CREATE TABLE THE_TABLE
> > (
> > ROWA varchar(255) binary NOT NULL default '',
> > ROWA tinyblob NOT NULL
> > )ENGINE=InnoDB, DEFAULT CHARSET=utf8;
> >
> > As far as I can see they are both 255 chars binary, (one can have
> > default while the other cannot).
> > Are they not both the same?
>
> I can't even see a ROWB???

Sorry there was a small typo,
...
ROWA varchar(255) binary NOT NULL default '',
ROWB tinyblob NOT NULL
)ENGINE=InnoDB, DEFAULT CHARSET=utf8;

Thanks

FFMG


--

'webmaster forum' (http://www.httppoint.com) | 'Free Blogs'
(http://www.journalhome.com/) | 'webmaster Directory'
(http://www.webhostshunter.com/)
'Recreation Vehicle insurance'
(http://www.insurance-owl.com/other/car_rec.php) | 'Free URL
redirection service' (http://urlkick.com/)
------------------------------------------------------------------------
FFMG's Profile: http://www.httppoint.com/member.php?userid=580
View this thread: http://www.httppoint.com/showthread.php?t=21957

Message Posted via the webmaster forum http://www.httppoint.com, (Ad revenue sharing).

On Wed, 7 Nov 2007 01:17:01 -0500, FFMG
<FFMG.2zo23i@no-mx.httppoint.com> wrote:

>
>Hi,
>
>I cannot see a real difference between ROWA and ROWB
>
> CREATE TABLE THE_TABLE (
> ROWA varchar(255) binary NOT NULL default '',
> ROWB tinyblob NOT NULL -- (corrected that 4 u)
> )ENGINE=InnoDB, DEFAULT CHARSET=utf8;
>
>As far as I can see they are both 255 chars binary, (one can have
>default while the other cannot).
>Are they not both the same?

You already found one difference.
There _might_ be functions that only accept blobs as a
parameter. I apologize for not taking the effort of
searching one.

>FFMG
--
( Kees
)
c[_] If I'm supposed to live every day like it's my
last, I want a gallon of morphine. (Russ Wallace) (#393)

Kees Nuyt;102227 Wrote:
> On Wed, 7 Nov 2007 01:17:01 -0500, FFMG
> <FFMG.2zo23i@no-mx.httppoint.com> wrote:
>
> >
> >Hi,
> >
> >I cannot see a real difference between ROWA and ROWB
> >
> > CREATE TABLE THE_TABLE (
> > ROWA varchar(255) binary NOT NULL default '',
> > ROWB tinyblob NOT NULL -- (corrected that 4 u)
> > )ENGINE=InnoDB, DEFAULT CHARSET=utf8;
> >
> >As far as I can see they are both 255 chars binary, (one can have
> >default while the other cannot).
> >Are they not both the same?
>
> You already found one difference.
> There _might_ be functions that only accept blobs as a
> parameter. I apologize for not taking the effort of
> searching one.
> --
> ( Kees
> )
> c[_] If I'm supposed to live every day like it's my
> last, I want a gallon of morphine. (Russ Wallace) (#393)

You must be right.
I doubt that having/not having a default value is a reason for a new
variable.

FFMG


--

'webmaster forum' (http://www.httppoint.com) | 'Free Blogs'
(http://www.journalhome.com/) | 'webmaster Directory'
(http://www.webhostshunter.com/)
'Recreation Vehicle insurance'
(http://www.insurance-owl.com/other/car_rec.php) | 'Free URL
redirection service' (http://urlkick.com/)
------------------------------------------------------------------------
FFMG's Profile: http://www.httppoint.com/member.php?userid=580
View this thread: http://www.httppoint.com/showthread.php?t=21957

Message Posted via the webmaster forum http://www.httppoint.com, (Ad revenue sharing).