Bug #15993
closedDatabase Analyser :: Update required tables :: COMPARE
0%
Description
Typo3@UTF-8:
Set:
$TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf-8';
$TYPO3_CONF_VARS['SYS']['multiplyDBfieldSize'] = '3'; (database does not support utf-8)
Call:
Database Analyser :: Update required tables :: COMPARE
Changing fields:
(only example!)
ALTER TABLE tx_realurl_uniqalias CHANGE value_alias value_alias text NOT NULL;
Current value: varchar(255) default ''
Write to database:
SQL-Statement (in background) doesn't work if the affected field "value_alias" is indexed. ["KEY bk_realurl02 (tablename,field_alias,field_id,value_alias,expire)"]
MySQL-Error #14798: BLOB/TEXT column '%s' used in key specification without a key length
The error isn't display in the "Install Tool" but can reproduced with "phpMyAdmin" for instance.
Solution:
KEY bk_realurl02 (tablename,field_alias,field_id,value_alias(255),expire)
(issue imported from #M3149)
Updated by Ingmar Schlecht over 18 years ago
It is suggested to not use multiplyDBfieldSize anymore but instead configure your database correctly for the use of UTF-8. Then the database automatically reserves enough space for your fields.
You might want to ask the mailinglists for how to configue MySQL.
cheers
Ingmar