Dynamic space reserve

Asked

Viewed 29 times

0

In other issues in Sopt, a question arose of those that generate doubts.

About the type VARCHAR, that has dynamic space allocation as stored data, I ask:

It’s different to use VARCHAR of VARCHAR(2)?

  • If I set this value, it will reserve the space?
  • This affects and/or limits the field view?
  • Affects and/or limits field data?
  • With types INTEIROS that changes?
  • 4

    What’s the difference to that? https://answall.com/q/190799/101 Don’t you have everything you need? Not together with https://answall.com/q/207849/101

  • That’s right. The problem with research is these titles, or I haven’t yet learned to research here man. I always suffer. That would answer " This 255 is just information of how it should be shown in a selection, it does not mean that it will occupy that disk space. There is no waste."

  • Varchar(2) dynamically stores up to 2 characters. As not informed which bank and never seen create a column with type varchar without parameter, I imagine it is equivalent to 'text', ie store dynamically without limit.

  • But I picked them up from a comment you made a few minutes ago.

  • @Lisângeloberti this has errors or inaccuracies, even by the ambiguity of the question.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.