[ vladimirn @ 26.01.2007. 09:47 ] @
Pozdrav svima,
Koliki je maskimum u jednoj tabeli? Da li je najoptimalnije koristiti polje LONGTEXT ukoliko imam puno karaktera, i koji je limit za takvu vrstu polja? Koliko tu slova moze stati?
Hvala unapred
[ Dejan Topalovic @ 26.01.2007. 10:47 ] @
http://dev.mysql.com/doc/refman/5.1/en/blob.html
http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html
[ vladimirn @ 26.01.2007. 12:52 ] @
Hvala Dejane.
Izvinjavam se sto nisam odmah napisao da sam to vec procitao ali da mi nije jasno i da jednostavno ne umem da izracunam koliko je to.
Citat:

LONGBLOB, LONGTEXT L+4 bytes, where L < 232
TEXT and BLOB columns are implemented differently in the NDB Cluster storage engine, wherein each row in a TEXT column is made up of two separate parts. One of these is of fixed size (256 bytes), and is actually stored in the original table. The other consists of any data in excess of 256 bytes, which stored in a hidden table. The rows in this second table are always 2,000 bytes long. This means that the size of a TEXT column is 256 if size <= 256 (where size represents the size of the row); otherwise, the size is 256 + size + (2000 – (size – 256) % 2000).



Nazalost meni ovo ne znaci puno i ne znam koliko je to "slova".
Bio bih zahvalan ako neko ume da mi pomogne i kaze da je to 'n' broj slova (karaktera).

Ps.
U koju vrsta polja u tabeli moze stati najveci broj slova?
[ Dejan Topalovic @ 26.01.2007. 14:05 ] @
LONGTEXT = 232 + 4 bajta. Znas li racunati potencije?
[ vladimirn @ 26.01.2007. 14:13 ] @
lol :)
Ne znam Dejane :)
Placam pivo za broj slova ;)
[ Dejan Topalovic @ 26.01.2007. 17:06 ] @
Moj digitron kaze: 4294967296.