Is it mandatory to specify length in case of varchar datatypes. Actually the jobs throw a lot of warnings in case we map fields of different lengths etc.
Would it not be simpler to leave the length blank ? Any downside to it?
Varchar datatype length issues
Moderators: chulett, rschirm, roy
Varchar datatype length issues
Neha Sharma
Seem to recall some very specific downsides to this, perhaps an exact search for "unbounded" would be in order? Filter out all of the XML specific results, however and you'll find ones like this and this just to cherry-pick a couple of examples. Others would have to chime in if this has changed in current versions.
Oh, and as an aside, it seems to me if you are getting "a lot of warnings" then you're not doing it right.
Oh, and as an aside, it seems to me if you are getting "a lot of warnings" then you're not doing it right.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers