mysql automatically changing varchar to char

[scarhand]

why is mysql automatically changing varchar to char?

 

i NEED the column to use CHAR(20), but when i insert the sql into the database it is changing it to VARCHAR(20)....

 

can anyone help me with this?

[fenway]

Probably because there are other varchar columns....

[scarhand]

i just changed the rest of the varchars to chars for that table, and now its automatically changing all of them to varchar...

 

DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `category_id` bigint(20) unsigned NOT NULL,
  `uploader_id` bigint(20) unsigned NOT NULL,
  `info_hash` char(20) binary NOT NULL default '',
  `file_name` char(255) NOT NULL,
  `tsize` bigint(20) unsigned NOT NULL,
  `title` char(255) NOT NULL,
  `description` text NOT NULL,
  `date_uploaded` timestamp(14) NOT NULL,
  `rating` smallint(5) NOT NULL default '0',
  PRIMARY KEY (`id`)
);

[scarhand]

i figured out its because i have TEXT in there

[fenway]

Yeah, my bad, I should have said all variable-length fields.