Yes I'm not a genius on SQL. Telling the truth I don't know almost anything.

Well.

Could somebody tell me the difference between BLOB and TEXT and why mySQL refuse to add into the database very very big descriptions (some are 300K!!!!).

PS. It's not a problem of linkSQL misconfiguration. I changed all setting according to these big strings. It's mySQL that returns an error.


Thank you in advance.


Lepo

What is the error you are getting?

Have you checked the MySQL home page, for their manual?

It's actually quite good, if utilitarian in format.

I believe the difference between BLOB and TEXT is that text expects "text" blob will accept anything without transformation. This is how most languages work, but I don't know if that's how MySQL makes the distinction. I believe "Blob" stands for "Binary Large OBject" and "GLOB" for "Graphics Large OBject"... but if the acronyms are off, the idea is the same.

I've been able to put 15,000 into the text fields, I haven't needed more than that.

Found the problem.

BLOB, TEXT
L+2 bytes, where L < 2^16

MEDIUMBLOB, MEDIUMTEXT
L+3 bytes, where L < 2^24

LONGBLOB, LONGTEXT
L+4 bytes, where L < 2^32


Thanks for your help!

lepo