mySQL NULL not read

[anonymous]

Null field values are returned as 0 for integers. I'm using using mySQL 5.0.

[Chris Graham <chris@…>]

Correction, they come out as empty strings. That means it's not so critical for me as I can differentiate based on that.

[Chris Graham <chris@…>]

NULL string fields are also returned as empty strings. Fortunately I can cope with this as I have avoided NULL strings in my database as Oracle can't do them -- I just need to clean up a few instances (non-matched JOINS).

[weyrick]

can you attach a quick script illustrating the problem? thanks

[anonymous]

<?php

/* DB...

CREATE TABLE table (

field int(11) NOT NULL, field2 int(11) default NULL, PRIMARY KEY (field)

) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO table VALUES (1, NULL);

DB version is MySQL 5.0.27-community-nt */

$conn=mysql_connect('localhost','root',); mysql_select_db('test',$conn); $r=mysql_query('SELECT field2 FROM table'); $row=mysql_fetch_assoc($r); echo gettype($rowfield2?); // Outputs 'string'

?>