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?
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
– Maniero
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."
– rbz
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.
– Lisângelo Berti
But I picked them up from a comment you made a few minutes ago.
– Maniero
@Lisângeloberti this has errors or inaccuracies, even by the ambiguity of the question.
– Maniero