<?php

include_once('config.php');

$tables = array(
    'testvarchar' => 'varchar(5)',
    'testnvarchar' => 'nvarchar(5)',
    'testntext' => 'ntext',
    'testnvarcharmax' => 'nvarchar(max)'
);

foreach($tables as $table=>$domain) {
    print "==$table==\n";
    mssql_query("create table null$table (test $domain null);");
    mssql_query("create table empty$table (test $domain null);");
    mssql_query("insert into null$table values(null);");
    mssql_query("insert into empty$table values('');");
    $r = mssql_query("select * from null$table;");
    $a = mssql_fetch_assoc($r);
    print "null->";
    var_dump($a['test']);
    $r = mssql_query("select * from empty$table;");
    $a = mssql_fetch_assoc($r);
    print "empty->";
    var_dump($a['test']);
    mssql_query("drop table null$table;");
    mssql_query("drop table empty$table;");
}

?>