[TYPO3-templavoila] Fixing wrong special chars in database / TV template before updating to 1.4.1

Steffen Kamper info at sk-typo3.de
Wed Dec 9 13:43:26 CET 2009


Hi,

Thomas Russel schrieb:
> Dmitry Dulepov schrieb:
>> Hi!
>>
>> On 08/12/2009 12:32, Thomas Russel wrote:
>>> First, I went to the install tool and enabled setDBinit to
>>> SET NAMES utf8;
>>> SET CHARACTER SET utf8;
>>
>> Get rid of the line above. It corrupts database output.
> 
> What line do you mean?
> What exactly must I put into the setDBinit field? If I don't enable it, 
> every german Umlaut (ö,ü) ends up wrong in the database.
> 
> 
>> Of course it will not. You cannot edit serialized data and hope that 
>> it will work. It uses length counters and other calculated values that 
>> become wrong after you edit this data. It will not unserialize.
> 
> Thanks you for the tip!!!
> So I can't edit anything in hope fixing it?

as said in the other thread: change db field to mediumtext in PMA.

vg Steffen


More information about the TYPO3-project-templavoila mailing list