MySQL Forums
Forum List  »  Docs

does bit type removed in new version or never esist before
Posted by: Benson zhang
Date: April 14, 2009 09:07PM

When I write hibernate mapping file, there is a attribute, it's type is boolean, according to my reference book the mapping type is bit. but when I push enter key,
I get the follow message:
Error 1178(42000) : The storage engin for the table doesn't supprot BIT FIELD.

so, I asked does bit type removed in new MySQL version.

my ddl is:
mysql> create table CUSTOMERS(
-> ID bigint not null primary key,
-> NAME varchar(15) not null,
-> EMAIL varchar(128) not null,
-> PASSWORD varchar(8) not null,
-> PHONE int,
-> ADDRESS varchar(255),
-> SEX CHAR(1),
-> IS_MARRIED bit,
-> DESCRIPTION text,
-> IMAGE blob,
-> BIRTHDAY date,
-> REGISTERED_TIME timestamp
-> );

Best regards

Options: ReplyQuote


Subject
Views
Written By
Posted
does bit type removed in new version or never esist before
5310
April 14, 2009 09:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.