[TYPO3] typo3 database utf-8 conversion

[Andreas Becker]

Hi Steffen and Ries

it does not convert all types of content - If this would be fixed it would
be very useful.
With convert2utf8 you get your tt_content converted but i.e. not tt_news - i
guess the same serialize problem.

I guess the only suitable solution might be to convert your database in to
binaries before performing the conversion with iconv.
Then editing the charset and collation settings in an text editor (depending
on how big this is pspad is a wonderful tool doing this)
Then restoring everything back into mysql.

When you convert your data into binaries before doing the conversion then
all types of arrays should work.

@ Steffen
What about mysqldumper.
It offers the export to utf8 - does it do any conversion?
Won't it be possible to dump a file directly to utf8 and then you create a
new database - setting charsets and collations to utf8 and restoring your
dumped utf8 file?
What actually is mysqldumper doing when it offers to export to utf8?

mysqldumper would be also a very useful tool to perform such a conversion,
as it offers to store and upload BIG datafiles without timeout problems.
Is there a chance to implement this utf8 conversion there if it isn't
already existing?

Andi