> info columns for host_privileges;

Column name          Type                                    Nulls

host_privileges_t    serial                                  no
name                 char( 32 )                                no
machine_name         char( 255 )                               yes
user_name            char( 255 )                               yes
password             byte                                    yes
chk_upd_dt           datetime year to fraction( 3 )            no

> insert into host_privileges values ( 1 , "SMSC01", "SMSC01", "PSA", "", '2010-11-01 10:00:00.000');

   617 : A blob data type must be supplied within this context.
Error in line  1 
Near character position  69 

insert into host_privileges values ( 1 , "SMSC01", "SMSC01", "PSA", null, '2010-11-01 10:00:00.000');

 1  row(s) inserted.