At 22:49 -0500 11/21/05, Ferindo Middleton Jr wrote:
>I have this SQL statement:
>CREATE TABLE rooms (
> id SERIAL,
> room_name TEXT UNIQUE,
> location TEXT,
> last_updated TIMESTAMP DEFAULT
>CURRENT_TIMESTAMP NOT NULL,
> last_user_updated TEXT,
> PRIMARY KEY(id)
>When I run this I get the following error:
>ERROR 1170 (42000): BLOB/TEXT column 'room_name' used in key
>specification without a key length
>I'm more used to PostgreSQL and when I run this command there, I
>don't get this error message. I recognized that by changing
>room_name to a varchar type, I won't get the error message.
>Also, the PostgreSQL mailing lists had a special group from
>SQL-related issue, but I didn't see one of these types of lists in
>the lists of groups for MySQL community so I'm sorry if I irritate
>anyone by posting to the wrong group. Thanks.
What is your question?
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com