Help! How to insert an empty string without converting to null

I am using JDBC to insert data into Oracle and MS SQL 7 databases. One of the major differences is that when I pass an empty string (e.g., String str = "") to MS SQL it does exactly what is expected - inserts a blank string into the database. Oracle, however, inserts a null value instead. So, when the data is retrieved, one can see str = null, rather then str = "".

I hope this is just the default behavior for Oracle and it can be changed. The question is how?

Thanks in advance,

Igor Received on Fri Sep 29 2000 - 19:44:24 CDT