Re: postgresql vs mysql - Mailing list pgsql-general

From Brusser, Michael
Subject Re: postgresql vs mysql
Date
Msg-id DAF7A2046DD4A24F8F77B086F840BF1907FE83EF@msx11am.matrixone.net
Whole thread Raw
In response to Re: postgresql vs mysql  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: postgresql vs mysql  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
>> How would you like to use a database that has nuances like these --
>> http://forums.mysql.com/read.php?20,141120,141120#msg-141120

---

> Huh?
> A blank string (does that mean '' or ' '?) is not NULL, so of
> *course* it should pass the NOT NULL constraint.
> Or am I missing something?

---

I agree with you, although Oracle won't, they really blurred the line
between the empty string and NULL.

As for MySQL maybe this article makes more sense:
http://www.databasejournal.com/features/mysql/article.php/3519116

Mike.



pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: postgresql vs mysql
Next
From: Ron Johnson
Date:
Subject: Re: postgresql vs mysql