No, empty string is not the same as NULL.
NULL is undefined
"" can equate "" for a varchar or " " (padded to whatever) for a char.
Why not use the NULL?? Unless you are from the SQL camp which says NULLs
are evil and the sign of a bad database design.
I use NULLs in the my database systems (ducking as Date shoots me), but they
are useful.
Thor HW
----- Original Message -----
From: Jason Puyleart <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 24, 1999 2:07 PM
Subject: JDBC - Servlet problem
> 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
