255 max char?

[slighltywhacked]

Is there a variable type that can hold more than 255 chars (well I know there is, I just dont know what it is) and is there a special way it ahs to be defined or used?

Thanx

[freddydoesphp]

In a database or regular old php? In a database a field type of text or blob can hold more, but I think you are talking about passing vars using GET and limit of GET string size, am I right?

If so you probably need to use POSt to get thos long variables through.

[slighltywhacked]

Im using PHP and MYSQL

right now I have a field in my database that is varchar(255)
but i want it to be able to hold more information
Im not using get or post methods

[slighltywhacked]

i dotn think..



Im using my sql query to update

[freddydoesphp]

A field type of text or blob is what you want, and if you are not storing binary data( ie, images...) then text is fine. It can hold quite a bit, I am not sure what the limit is but I know its a lot more than varchar.

From the MySQL manual

TEXT can hold 65535 characters
MEDIUMTEXT can hold 16777215 characters
LONGTEXT can hold 4294967295 characters

[slighltywhacked]

tanx man...er..cat

[slighltywhacked]

is it defined as...

variablename text

? that simple?

[freddydoesphp]

It is the design of the table, it doesn't have anything to do with variables. When you insert data in to the db, if the db tables column length is not long enough it will truncate the data at the last character for the column width.