form

[jimfog]

I am using ajax to update a db table where it contains data sent from a form.

 

In this form there is a wwwaddress field where the user can enter(if he want to) his/her website url-it is optional.

 

My question is the following:

 

I have selected that the wwwaddress data contained in the input field even if it is empty(meaning an empty string which means the user has not filled it) will be sent either way in the server for updating the table column where the web address of the user is kept.

 

The question is if it something "bad" from a database point of view, having a column where it might have empty strings?

 

That said, if 10 users choose not to fill the corresponding input field the table will have a column with 10 empty strings.

[justsomeguy]

There's nothing bad about empty strings.

[jimfog]

thanks

[davej]

There is nothing bad about strings or empty strings, except that you might want to guard against any possible misuse. You could even get fancy with something like...

 

http://www.dailyblogtips.com/check-if-a-website-is-blacklisted/

 

http://www.blacklistalert.org/