jimfog Posted July 3, 2013 Share Posted July 3, 2013 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. Link to comment Share on other sites More sharing options...
justsomeguy Posted July 3, 2013 Share Posted July 3, 2013 There's nothing bad about empty strings. Link to comment Share on other sites More sharing options...
jimfog Posted July 3, 2013 Author Share Posted July 3, 2013 thanks Link to comment Share on other sites More sharing options...
davej Posted July 4, 2013 Share Posted July 4, 2013 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/ Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now