BLOB/TEXT columns can't have default values?

15/10/2007, 01h17

Say I try to run the following on MySQL 5:

CREATE TABLE test (
test TEXT NULL DEFAULT ''
);

Doing so yields a "BLOB/TEXT column 'test' can't have a default value"
error. Given that, why does the following work?:

CREATE TABLE test (
test TEXT NULL DEFAULT NULL
);

15/10/2007, 04h47

yawnmoth wrote:
> Say I try to run the following on MySQL 5:
>
> CREATE TABLE test (
> test TEXT NULL DEFAULT ''
> );
>
> Doing so yields a "BLOB/TEXT column 'test' can't have a default value"
> error. Given that, why does the following work?:
>
> CREATE TABLE test (
> test TEXT NULL DEFAULT NULL
> );
>

Because NULL is not a value. It is a state.

Norm

15/10/2007, 01h17	#1
yawnmoth Messages: n/a Hébergeur:	BLOB/TEXT columns can't have default values? Say I try to run the following on MySQL 5: CREATE TABLE test ( test TEXT NULL DEFAULT '' ); Doing so yields a "BLOB/TEXT column 'test' can't have a default value" error. Given that, why does the following work?: CREATE TABLE test ( test TEXT NULL DEFAULT NULL );

15/10/2007, 04h47	#2
Norman Peelman Messages: n/a Hébergeur:	Re: BLOB/TEXT columns can't have default values? yawnmoth wrote: > Say I try to run the following on MySQL 5: > > CREATE TABLE test ( > test TEXT NULL DEFAULT '' > ); > > Doing so yields a "BLOB/TEXT column 'test' can't have a default value" > error. Given that, why does the following work?: > > CREATE TABLE test ( > test TEXT NULL DEFAULT NULL > ); > Because NULL is not a value. It is a state. Norm

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email