Hi,
I got the following information from the oracle manual.
*******************************************
Nulls
If a column in a row has no value, then column is said to be null, or to
contain a null. Nulls can appear in columns of any datatype that are not
restricted by NOT NULL or PRIMARY KEY integrity constraints. Use a null when
the actual value is not known or when a value would not
be meaningful.
Oracle7 currently treats a character value with a length of zero as null.
However, this may not continue to be true in future versions of Oracle7.
Do not use null to represent a value of zero, because they are not equivalent.
Any arithmetic expression containing a null always evaluates to
null. For example, null added to 10 is null. In fact, all operators (except
concatenation) return null when given a null operand.
*****************************************
Try to initialized the string to " " , the means a space.
TAMIL
****************************
Brendan Johnston wrote:
> This is the way Oracle seems to work.
>
> I don't think any other database has this problem.
>
> I don't know any good workarounds.
>
> Brendan
>
> Jason Puyleart <[EMAIL PROTECTED]> on 08/24/99 02:07:56 PM
>
> To: [EMAIL PROTECTED]
> cc: (bcc: Brendan Johnston/Contractor/CF/CCI)
> 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
___________________________________________________________________________
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
