[freetds] freebcp: add support for escaping characters?

Bort, Paul pbort at tmwsystems.com
Fri Mar 31 13:50:56 EST 2006


> 
> Ahem.  I understand they're technically different, of course, 
> but how are
> they semantically different?  Which user can tell the 
> difference between a
> null field and a zero-length string?  And what is the 
> difference between
> an empty field and a field that's empty?  
> 

Just a quick example from my current project of how '' and NULL are
different and that difference can be important:

We have a table that holds user settings, and a null ( or a missing row
) means that the default (from a separate table) should be used. OTOH,
if the column is an empty string, that means that the setting should be
an empty string, even if the default says otherwise. If a setting is a
file prefix, an empty string is a reasonable value.



More information about the FreeTDS mailing list