Yes, an empty string (ie. "") in Oracle is NULL.


Bart Cassady
Database Analyst
Associated Engineering Group Ltd.
[EMAIL PROTECTED]

>>> Jason Puyleart <[EMAIL PROTECTED]> 08/24 3:07 PM >>>
Hi.

This may be somewhat more JDBC orientated, but I was hoping that I could
get some help.

I am using Oracle 7 with the JDBC thin drivers.

I have a servlet that updates/displays values from a table.
The problem is that if I have an empty form value
(a string initialized to ""), when I retrieve from the database I get
a value of null.

Is this correct?  If so, how do I get an empty value into the database
without returning null?  Is NULL the same as the empty string?

Thanks in advance!!

Jason

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to