Max size of 'TEXT'

ZaZall

I would like to know where you can change so that TEXT can be more then 255 chars long.

I know that char() only can be 255 but why is TEXT at the maximum at 255 aswell, i need to make it larger or something for a forum that im making.

This is mysql.

Or is there another way to get around this?

Houdini

It is not TEXT is 65K see MySQL reference

Sxooter

64k? I guess that's enough for most purposes. 😃 Other databases have slightly higher max text size:

pgsql character types

"In any case, the longest possible character string that can be stored is about 1 GB."

🆒

ZaZall

Hrm, strange. Then could it be that the html/encrypting is wrong on my forums ? Because when i have used text it only saves 255 chars. Wish well, aint that much when it comes to forum messages.

bogu

Maybe u are using tinytext or tinyblob?

Sxooter

are you using ODBC or something like that to interface to the database? I'm guessing something in your setup is artificially limiting the max size of your text types, and one of the most common of those is odbc converting text to varchar(255). I think it's the "memo" type that's longer, but I'm not sure. Got more info you can help us help you with?

ZaZall

Sxooter wrote:
are you using ODBC or something like that to interface to the database? I'm guessing something in your setup is artificially limiting the max size of your text types, and one of the most common of those is odbc converting text to varchar(255). I think it's the "memo" type that's longer, but I'm not sure. Got more info you can help us help you with?

Ive been using the mysql consolse directly in linux, could it be that i have been using the mysql-small.cnf file?

create table forum (
forum_id int not null auto_increment,
forum_fid int not null,
forum_name char(40),
forum_text text,
user_id int not null,
forum_date int not null,
primary key(forum_id))

Sxooter

No, that's not the problem. That conf file just configures MySQL to run on a small server. It doesn't change the max size of the text field. Is your ODBC connector set to map text type to memo?