Problems testing an ODBC field with is_null

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
sebastian
Forum Newbie
Posts: 1
Joined: Wed May 28, 2003 5:03 pm

Problems testing an ODBC field with is_null

Post by sebastian »

(PHP 4.3.1 / MS-PWS / W98SE / Access2000 through ODBC)

I'm having a problem when I try to verify if an odbc field from an SQL query is null.
I've tried to test it whith 'is_null(odbc_result(.....' or to assign the field value to a variable and test the variable with 'isset'. The field is null in my DB but it is a 'boolean(false)' according with PHP (!?).
Is this something known with ODBC/Access? Is there some kind of php.ini configuration I have to alter to let PHP read the null values as real NULLs?
Any help will be really appreciated. Thanks in advance!!
Post Reply