Hello,
I used the book PHP fast & easy book which had some PHP code for creating
tables. THe code worked but mysql seems to change (with no pattern that I can understand varchar to char and visa versa). I have printed out the sql create statement prior to executing it that is built by the PHP code
for instance : CREATE TABLE teacher (id char (5) not null,name varchar (40) not null,email varchar (30) null,level varchar (5) null, UNIQUE id(id))
but when I look at the table using the explain command
all the fields are defined as varchar. The size of the field and other
options I selected are correct.
Any ideas?
Thanks,
Maureen