[TYPO3] install tool doesn't update database

[Joerg Wagner]

See
http://bugs.typo3.org/view.php?id=5495


"Joerg Wagner" <jwagner at digilog.de> schrieb im Newsbeitrag 
news:mailman.1.1177522278.19293.typo3-english at lists.netfielders.de...
> Christoph,
>
> does the install tool show you something like
>    ALTER TABLE be_groups CHANGE title title varchar(50) NOT NULL default 
> '';
>    Current value: varchar(50) binary default ''
> ???
> (Note the "binary" in the Current value line)
>
> If so you have probably set the collation of your Typo3 MySQL db to 
> latin1_bin.
> The install tool is not prepared for that. Try to change the collation of 
> the DB and of all tables and columns to something like latin1_german1_ci .
> Best way to do this:
> Dump the db,
> erase all occurrences of  "COLLATE latin1_bin",
> change all occurrences of  "COLLATE=latin1_bin" to 
> "COLLATE=latin1_german1_ci",
> delete all tables from the db and reimport.
>
> Hope that helps.
> --
> Jörg Wagner.
>
>
> "Christoph Koehler" <christoph.koehler at gmail.com> schrieb im Newsbeitrag 
> news:mailman.1.1173231574.5216.typo3-english at lists.netfielders.de...
>> Hello there,
>>
>> This is a problem I have had for a while: I cannot update the db from the 
>> install tool compare. Using TYPO3 4.1 now, MySQL 5.0.22, PHP 5.1.2, 
>> Apache 2.0.55.
>> It reloads the page, but the modifications are still there to be 
>> executed. Checking the db with phpmyadmin confirms no changes.
>>
>> Thanks!
>>
>> Christoph
>
>