Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to set default value of column with datatype varchar to empty string

    @lalit.singh
    Recommendations Offline Message

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 487
    Comment on it

    We usually face this kind of issue when we are doing programing with respect to a column with varchar data-type. If we don't add any value to a particular column it takes it as NULL. Thus forcing the developer to check for NULL every-time other then blank string like ''.

    This can be easily achieved by making entry of

    default value as ''

    for that respective column.

    mysql SQL Server
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: