At 10:11 PM -0500 7/25/01, Mike wrote:
>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?
I doubt if "they" are trying to irritate you. The maximum size of a MySQL
database depends on your file system constraints, not on the size of
Some OSes have a max file size of 2GB, for example; others don't.
>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?
Either can hold anything. The only difference is that BLOB types are case
sensitive and TEXT types aren't.
>I have plenty more questions but I will try to answer them on my own first.
>Tata and thanks for your time,
>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.
Paul DuBois, paul@stripped