VarChar and NVarChar are variable width character fields (thus var+char). You have to set the length, otherwise the default is zero.
VarChar and NVarChar are variable width character fields (thus var+char). You have to set the length, otherwise the default is zero.