I have throughly looked at the documentation and I am beginning to get frustrated. It
says that a LONGTEXT field's max length is L+4 bytes, where L < 2^32. I understand the
extra 4 bytes(+4) which is to keep track of the size sense LONGTEXT is no more than a
really big VARCHAR field. If my calculations are correct that is 4294967296 bytes or
just over 4Gig. Am I right or way off? If I am correct, I remember reading that is
about the max size of a MySQL DB. And why couldn't they just come out and say this is
the max size of the LONGTEXT. Do they just want to irritate me?
Anyway, my second question is, in this field I will want to save formatting characters
such as newlines, etc... Is it LONGTEXT what I want or do I want to use blob?
I have plenty more questions but I will try to answer them on my own first.
Tata and thanks for your time,
Mike
1 John 2:1 My little children, I write these things to you so that you may not sin.
And if anyone sins, we have an Advocate with the Father, Jesus Christ the righteous.
