Hi,

Iím trying to create a members table in MySQL using the Email address of the member as a primary key. So, with my limited knowledge of SQL, I type in the following command at the TelNet prompt:

CREATE TABLE Member (
Email TEXT NOT NULL PRIMARY KEY,
Password TEXT,
FirstName TEXT,
LastName TEXT
);

Iím then, however, presented with the following error message:

ERROR 1073: BLOB column ĎEmailí canít be used in key specification

Why am I getting this error, and how do I create a table with the Email address as the primary key?

Thanks in advance !