From: Jeff Smelser
Date: October 27 2005 8:22pm
Subject: Re: Bug? Set Null Value in NOT NULL field...
List-Archive: http://lists.mysql.com/mysql/190958
Message-Id: <200510271522.21403.tradergt@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed;
  boundary="nextPart4392388.FsbuvQ2I1O";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart4392388.FsbuvQ2I1O
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Wednesday 26 October 2005 04:24 pm, LMS wrote:
> Hi,
> I have this structure:
> -----------------------------------------------
> CREATE TABLE tabla (
>    id int(10) unsigned NOT NULL auto_increment,
>    nombre varchar(100) NOT NULL default '',

because your defaulting it to ''.. so null = '' on insert..

Jeff

--nextPart4392388.FsbuvQ2I1O
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQBDYTb9oOk9EvUvEtgRAvWIAKDbXpN8FquyUsn8h3GusSH3XSORBQCgx9qV
8I6A9gk7KaR6nZyWZQ7/w6s=
=4xpi
-----END PGP SIGNATURE-----

--nextPart4392388.FsbuvQ2I1O--