O$: Null Fields

[Joe Maus]

> We don't store any NULL's in our database, except for dates in db's  
> that don't allow blank dates, so before any insert, update we do a  
> simple sendall to set every NULL field to '' or 0 depending on its  
> type.  Works for us, maybe not for everyone.

Won't work on Oracle.  Just try storing '' using Oracle - it will convert it to null.  Several other backends do the same thing, that is, empty = null when the database actually goes to store the empty field.

Regards,

Joe Maus