[TYPO3] typo3 database utf-8 conversion

[Ernesto Baschny [cron IT]]

Thomas Oppelt wrote: on 15.01.2008 16:27:

>>>>> http://www.google.ca/search?q=typo3+utf-8
>>>>>
>>>>> First hit!
>>>>>
>>>>> Then:
>>>>> http://wiki.typo3.org/index.php/UFT-8_support#Convert_an_already_existing_database_to_UTF-8 
>>
>>
>>
>>>> one warning and is shown wrong on many links,
>>>> when you use a resent version of mysqldump, then you don't have to 
>>>> encode your
>>>> dump with iconv or other tools since the dump is already in utf-8.
>>>>
>>>> Ries
>>>
>>> But does this prevent me from these cases where a s:4:"öäüß"; in 
>>> latin1 is s:8:"öäüß"; in utf-8.
>>> So if you try to unserialize such a string after conversion u get 
>>> just false, or not?
>>
>> I guess you will have to "script" that converter on your own, because 
>> no "automatic" converter will work with PHP-serialized array. I 
>> haven't really found the need to do that, in most cases the serialized 
>> arrays are either some "minor" configuration that can be adapted by 
>> hand after converting everything else, or some cached stuff that we 
>> can clean up afterwards anyway. Isn't that the case?
>>
>> Cheers,
>> Ernesto
> 
> i HOPE this is the case, i don't know if typo3 just stores temp data 
> like caching data as serialized array/strings...what be nice if someone 
> could say "no prob u can be unconcerned about that".

Try it. Clear all your cache, and then make a dump from the rest. How 
many serialized arrays are left?

Cheers,
Ernesto