Re: Column Data Type Question

[Peter Brawley]

drop table t;
create table t(semester varchar(5));
insert into t values('2006S');
select * from t;
+----------+
| semester |
+----------+
| 2006S    |
+----------+

Let's see the result of Show Create Table for your table.