MySql Database! Text Limit on Tables!

[Anon]

how do i make the the text that it can hold bigger cause i need it for a guestbook and when i change it to large blob i get an error. help please.

[chowdary]

Hi Richie,
Do you want to set the maximum data you can store in that filed(restrict)? or simply you need chnage the data type of the field?
I think for guest book TEXT data type is enough.If you have set the field as VARCHAR type use this query
$qry="alter table $tablename modify $fieldname TEXT";

[Anon]

MySQL said: You have an error in your SQL syntax near '(2000) ' at line 1

i get this error when trying to change to text or blob.

[Anon]

table is guestbook field is $comments i just wanna make it as big as possible so people can sign my guestbook. Can u just make the code so i can copy and paste it? and where do i paste this?? Sorry... i dont know much about this stuff.. Cause im just usin the script.. Thanx.. please help..

[Anon]

oh yea and im also usin php my admin... So tell me how to do it with that..

[Anon]

Using the mysql client you need to perform this query:
ALTER TABLE guestbook CHANGE comments comments TEXT;

The upper limit is 65KB, which is one hell of guestbook entry 🙂

[Anon]

this is what i get when i do that

MySQL said: BLOB column 'comments' used in key specification without a key length

tell me what i should do

[Anon]

Why have you put the comments field as part of the key?! I suggest you pick up a book on MySQL or SQL in general, and learn the basics of relational databases, otherwise you will just struggle like a dog with problems like this. If I could see the create statement for the table or a copy of it's design (using DESCRIBE) for example, I might tell you how to rewrite the table to suit it's purpose, but I still think you should spend some time learning SQL basics so that you can actually solve simple problems like this one yourself.