TYPO3 Core

Using the "Compare"-function from the Database Analyser fails to create the table "sys_refindex" with the following error message if $TYPO3_CONF_VARS[SYS][multiplyDBfieldSize]=2 is used (the database analyser than tries to create a field of type TEXT instead of VARCHAR):

BLOB/TEXT column 'ref_string' used in key specification without a key length

To solve this a length has to be assigned to the key referencing the column "ref_string".

This happens because MySQL needs to know how many bytes of a BLOB column should be indexed. See [1] for an explanation.

The MySQL version used on the server- or client-side is not relevant here.

This error is likely to happen in other extensions as well when index is used on BLOB columns.

[1]<http://groups.google.com/group/mailing.database.myodbc/msg/2055be92b8d210e4>

(issue imported from #M3015)