In jet databases. Text columns have an option "Allow Zero Length" which can be set Yes or No.

Has the behaviour changed? In my vb6 application If "Allow Zero Length=No" then an empty string is allowed but null isnt. So, using an sql INSERT naming all fields and inserting '' empty strings into each field is no problem.

But in .Net Oledb/jet4 an empty string is not allowed. The string has to contain 1 or more characters.?

Is that right or is something else going on?