Re: MySQL and foreign-key support

[prev] [thread] [next] [lurker] [Date index for 2006/10/24]

From: Philip Newton
Subject: Re: MySQL and foreign-key support
Date: 06:14 on 24 Oct 2006
On 10/24/06, Peter da Silva <peter@xxxxxxx.xxx> wrote:
> On Oct 23, 2006, at 1:16 PM, Philip Newton wrote:
> > And let's not even get started with databases who won't let you insert
> > empty strings into VARCHAR columns, turning them into NULL instead.
>
> Sure that's the DB and not some hateful access library that's covering
> for a shortcoming in the language runtime?
>
> A lot of them want you to specify the string to use as "null value".

Pretty sure. It does it even in the supplied interactive SQL console,
and a couple of Google hits imply that it's a "feature" that's been
part of that particular engine for quite a while.
-- 
Philip Newton <philip.newton@xxxxx.xxx>
There's stuff above here

Generated at 16:01 on 02 Nov 2006 by mariachi 0.52