nicht angemeldet
Hi,
Aus der MySQL Hilfe:
VARCHAR and the BLOB and TEXT types are variable-length types, for which the storage requirements depend on the actual length of column values, rather than on the type's maximum possible size. For example, a VARCHAR(10) column can hold a string with a maximum length of 10 characters. The actual storage required is the length of the string (L), plus 1 byte to record the length of the string. For the string 'abcd', L is 4 and the storage requirement is 5 bytes.
The BLOB and TEXT types require 1, 2, 3 or 4 bytes to record the length of the column value, depending on the maximum possible length of the type.
Also nimm ein TEXT teil wobei:
TINYTEXT -> 2^8 Zeichen
TEXT -> 2^16 Zeichen
MEDIUMTEXT -> 2^24 Zeichen
LARGETEXT -> 2^8 Zeichen
Es gibt(oder gab?) aber einschränkungen beim suchen was diesen Typ anbetrifft, wenn ich mich recht erinnere.
Machs gut
Tina