Ok co the current limit on the VARCHAR2 is 4000. So when you have a variable amount of text, even if you expect it to one maybe a couple hundred chars long, you usually just sst it at 4000. Just to be sure.
SO what I want to know is lets say the max amount os oh 32000. What is the number you'd set the VARCHAR2 to for your basic field that you dont expect to go over a couple hundred chars but you want to make sure things dont crash. Will you stick at 4000? Use the 32000? Use 255 to maintain some some sort of backasswards Access compatibility?
No comments:
Post a Comment