Re: Code not working

[stefan sonnenberg]

Shouldn't it be somthing like this :

CREATE TABLE blenders(
productID CHAR(10),
reviewerID CHAR(10),
date CHAR(10),
reviewtype CHAR(10),
filename CHAR(10),
productrating CHAR(10),
easeofuse CHAR(10),
easeofcleaning CHAR(10),
durability CHAR(10),
style CHAR(10),
pros CHAR(10),
cons CHAR(10),
contents CHAR(10))

e.g. adding the number of chars ?
Perhaps MySQL assumes you like to store only 0 chars.

See this:
http://dev.mysql.com/doc/refman/5.1/en/char.html

What does "e" contain, or is the exception never thrown on this ?