List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 26 2001 2:54am
Subject:Re: BLOB and LONGTEXT question
View as plain text  
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
BLOB and LONGTEXT questionMike26 Jul
  • Re: BLOB and LONGTEXT questionPaul DuBois26 Jul
    • Re: BLOB and LONGTEXT questionMohamad Ilhami26 Jul