[asterisk-dev] NULL from MySQL database not NULL?

Tilghman Lesher tilghman at mail.jeffandtilghman.com
Wed May 6 16:14:52 CDT 2009


On Wednesday 06 May 2009 14:52:44 Chris Maciejewski wrote:
> I would argue with this because my "null" value in the database is not
> a literal "null" string, but the actual null value. It is a result of
> the following query: "UPDATE table SET some_null_col = NULL WHERE id =
> 1"
>
> So the actual value of some_null_col is NULL and not "NULL" and once
> such a value is assigned to a channel variable, that variable is NULL,
> therefore ISNULL function should return 1.

Again, the ISNULL function has no relation whatsoever to your database.

-- 
Tilghman



More information about the asterisk-dev mailing list