Hi, Dirk
Thank you for your advice, my problem is cleared.
>create table objects(uri blob not null, unique index(uri(255)), classname blob);
Regards.
___________________________________________
Kiyoko Takanabe
----- Original Message -----
From: "Dirk Verbeeck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 6:14 AM
Subject: Re: ERROR 1073: create database specify "type=InnoDB"!
> Kiyoko Takanabe wrote:
>
> > Hi,
> >
> > I tried create database specify "type=InnoDB".
> > with the following script:
> >
> > >create table objects(uri blob not null, primary key uriIndex (uri(255)),
> > classname blob) type=InnoDB;
> >
> > I'm getting the following error
> >
> > ERROR 1073: BLOB column 'uri' can't be used in key specification with the used
>table type
> >
> > Is it supported with slide? If yes, please let me know how?
> > Any help is welcome.
>
> This is what I found in the mySQL docs:
> * Only the MyISAM table type supports indexing on BLOB and TEXT columns. When
>putting an index on a BLOB or TEXT column you MUST
> always specify the length of the index:
> CREATE TABLE test (blob_col BLOB, index(blob_col(10)));
>
> You could change the uri to varchar but...
> * Values in VARCHAR columns are variable-length strings. You can declare a VARCHAR
>column to be any length between 1 and 255,
> just as for CHAR columns.
>
> That's not very good, you can choose
> - transactions but uri limited to 255 chars
> - no limit but also no transactions
>
> If you can live with no transactions use the slidestore.mysql.MySQLDescriptorsStore
>that was created for older version of mySQL.
>
> Maybe ask the mySQL mailing list for a solution.
>
>
> Dirk
>
>
