Hi,
Sorry, I think my idia is wrong.
I couldn't solve the problems.
There is no indexing the BLOB columns with InnoDB tables in MySQL yet.
I'll ask the mySQL mailing list for a solution and send you the results.
regards.
Kiyoko
----- Original Message -----
From: "Kiyoko Takanabe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 5:26 PM
Subject: Re: ERROR 1073: create database specify "type=InnoDB"!
> 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
> >
> >
>
>
