creation check?

[imnsi]

whats wrong with my contacts db..

CREATE TABLE contacts (

LastName BLOB BINARY NOT NULL ,
FirstName BLOB BINARY NOT NULL ,
Company BLOB BINARY NOT NULL ,
Title BLOB BINARY NOT NULL ,
Phone BLOB BINARY NOT NULL ,
Fax BLOB BINARY NOT NULL ,
Address1 BLOB BINARY NOT NULL ,
Address2 BLOB BINARY NOT NULL ,
City BLOB BINARY NOT NULL ,
State TINYTEXT BINARY NOT NULL ,
Zip INT BINARY NOT NULL ,
Country BLOB BINARY NOT NULL ,
URL BLOB BINARY NOT NULL ,
Email BLOB BINARY NOT NULL ,
Refferer BLOB BINARY NOT NULL ,
Password BLOB BINARY NOT NULL ,
Date DATE BINARY NOT NULL ,
PRIMARY KEY ( Email ) ,
INDEX ( LastName , Company )
) COMMENT = 'nsi'

[matto]

why is nearly everything 'blob binary'?
check out the available datatypes in your db's (mysql?) reference. afaik (I didn't use blobs yet) you can't insert into them using simple sql statements.

and, don't quote table/column names.

I would do:

CREATE TABLE contacts (
email text primary key,
LastName text,
FirstName text,
...
Zip int,
...
CreationDate date,
...
)