Page 1 of 1
Varchar datatype length issues
Posted: Mon Mar 25, 2019 6:21 pm
by nehavin
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?
Posted: Tue Mar 26, 2019 1:07 am
by chulett
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.
