mySQL datatype for extra long field

[DLG_1]

i want a field that could hold many, many, many lines of text.

data type?



thanks,

Sam

[freddydoesphp]

longtext or longblob

[DLG_1]

thanks!!!
what's the max?

[Son Nguyen]

This is from MySQL docs:

LONGBLOB
LONGTEXT
A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters.

[DLG_1]

why am I getting this error?


Error

MySQL said: You have an error in your SQL syntax near '(1000) not null ' at line 1
Back

[Son Nguyen]

Got it from phpMyAdmin, correct (looks so similar!)
Post the query here and let us analyze!

[DLG_1]

Field ==> status_report
Type ==> LONGTEXT
Length/Set ==> 1000
Attributes ==>
Null ==> not null
Default ==>
Extra ==>

[mkaufman]

Why not just use a 'text' field?

[DLG_1]

can it be 1000 long?

[DLG_1]

so what am I doing wrong?

[DLG_1]

so nobody knows?

[Hartmann]

When you set it up do not set a length... Do not worry about it.

[DLG_1]

what's the max? and what's the next highest?



Sam

[freddydoesphp]

Go check out column types in the documantation at http://www.mysql.com

[DLG_1]

i've tried looking at the documentation, but I can't find a clear answer.

just need the longest data type and it's max.


anyone who's experience with mysql should know this answer, it's simple.


sam

[Hartmann]

Just use longtext and do not put a value for it.
Restrict the number of characters on the client side....

BTW, this is the quickest and easiest solution.

[freddydoesphp]

LONGTEXT
A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters. See section 7.7.1 Silent Column Specification Changes. Note that because the server/client protocol and MyISAM tables has currently a limit of 16M per communication packet / table row, you can't yet use this the whole range of this type.

From the mysql manual(took me 10 sec. to find it)

LONGTEXT holds 4294967295 characters. you don't put a length on this type of field when defining it
IE

CREATE table test (
id INT(11) NOT NULL PRIMARY KEY,
text LONGTEXT
);

[DLG_1]

very cool. what's the max?

what would be the "other way?"



Thanks,

Sam

[DLG_1]

thanks! appears that the last time that i tried using the longtext i was entering some invalid characters.

see for yourselves... http://www.dlgsolutions.com/test2.php3
username: c
password: c

thanks!


Sam

[jumpthru]

Isn't blob for holding binary files...not text...?

[Son Nguyen]

I don't know much about blob, never have to use that data type before. So what do you use blob for?