This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Null or blank String into database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Null or blank String into database " Watch "Null or blank String into database " New topic
Author

Null or blank String into database

bhargav shankar
Greenhorn

Joined: Jan 10, 2008
Posts: 8
Hi ,

i have a jsp form, user is going to fill the form.

if user doesn't fill any filed in the form then what should i insert into database for that filed. is it a blank string or null?

waiting for the answer.

thanks in advance


bhargav
Nishan Patel
Ranch Hand

Joined: Sep 07, 2008
Posts: 684

Hi Bhargav,

That is depending on you.... No matter what you insert into database..it does not make sense.... blank string or null...



Thanks, Nishan Patel
SCJP 1.5, SCWCD 1.5, OCPJWSD Java Developer,My Blog
bhargav shankar
Greenhorn

Joined: Jan 10, 2008
Posts: 8
Thanks nishan,

but is there any use if i insert null into database ?

Which is the better option?
Nishan Patel
Ranch Hand

Joined: Sep 07, 2008
Posts: 684

Just make your flied into database not null= false and that will automatically set null value when user not input any thing..
I recommend insert null instead of blank string.
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
What are the requirements of your application. First of all, it looks liek the field is nto required. If that's not the case, then validate on the client to make sure something is entered before allowing form submission. If the field is not a required field, then is the column defined as not null in the database table?


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Blank strings and null values are different for a reason, they have different logical meanings. Suppose you have a table with a field called "my_string_value" and allow your domain model to represent no value as a zero length string. How do you now query the database for all records where "my_string_value" is not set? You have to use database functions to do this, which can be inefficient and often database specific. If its null you can easily test.

Another thing to consider: in Oracle, you cannot store a zero length string. So if you have the same field you must default it to a single space (or some other suitable default).


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Null or blank String into database
 
Similar Threads
Values in a text field
Updating timestamp field
not-null constraint in not working
how to handle Null values?
Problem in updating the fields to database