[thesite] Voting Application - initial DB ideas

[Andrew Forsberg]

>  >What does mysql use for something that needs more than 255 chars (i.e., a
>>couple paragraphs of description and links to archive postings, etc)?
>>
>>(I won't need to know for this particular project, but I'm curious anyway).
>
>TEXT fields: LONGTEXT (2^32 chars), MEDIUMTEXT (2^??? chars), TEXT (2^16
>chars)
>
>probably easy to find the size on MEDIUMTEXT on mysql.com if i weren't so
>lazy...

TINYTEXT, TINYBLOB (2^8 - 1 bytes)
TEXT, BLOB (2^16 - 1 bytes)
MEDIUMTEXT, MEDIUMBLOB (2^24 - 1 bytes)
LONGTEXT, LONGBLOB (2^32 - 1 bytes)

Cheers
Andrew

--
Andrew Forsberg
---
uberNET - http://uber.net.nz/
the pander - http://thepander.co.nz/