[TYPO3] typo3 database utf-8 conversion

Thomas Oppelt t.content at gmx.de
Fri Jan 18 13:20:03 CET 2008


ries van Twisk schrieb:>
> Su theoretically the only correct way to convert a latin-x database to 
> utf-8 is do it programatically,
> that is you simply load each record and each field of each table. Check 
> if it's a serialized array.
> If so, de-serialize it and then re-load it (using a other DB connection) 
> into a new utf-8 database.
> I have done something like that to migrate a mysql database to 
> postgresql and it works perfectly.

For now this seems to be the "safest" way to me...

@all: thanks for discussion, i see this IS an issue.



> 
> During the conversion from latin-x to utf-8 you have a change that 
> single byte characters get's converted
> to 2 or more byte characters and that the length indicator of a 
> serialized object is wrong.
> 
> clear enough? or is there still doubth? anyone? and correct me if I am 
> wrong!
> 
> Ries
> 
> 
> 
> 
> 
> 
> 


More information about the TYPO3-english mailing list