Creating a fixed length char field...

I have a question regarding fixed width char fields. How do you create them in MySQL? When I create a table and define a field MyField char[50], when I run the describe table, the field shows up as a varchar. Thanks, -- Jason H. West Software Engineer Softek Software International, Inc. 813

Re: Creating a fixed length char field...

If your create table statement has both char's and varchar's in it, then MySQL converts the char's all to varchar's. - Before posting, please check: http://www.mysql.com/manual.php (the manual)