question

[Guest]

When i insert "" to db (integer type), it will become 0
how to insert null when the text is ""

 

[Eliyahu Goldin]

The best way of inserting nulls is just skipping the column in the insert
statement. Don't write to it and it will be null unless there is a default
value set for the column. BTW, it's always a good idea to specify what
database you are working with.

Eliyahu

 

[Nathan Sokalski]

My recommendation would be to simply do some String manipulation and replace
the "" with whatever keywords or control characters represent null in the
database you are using. This shouldn't be too hard, but you have not given
us enough information to do it for you.

 

[Christopher Reed]

In general, in an UPDATE statement, you can usually use SET field1 = NULL.