[MySQL]ERROR 1073 (42000) problem

solution1

我在某個地方找到的:
 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.

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.

留言

這個網誌中的熱門文章

電腦網路project