[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.
留言
張貼留言