Re: [TYPO3] typo3 database utf-8 conversion

2008-01-18 Thread Thomas Oppelt
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

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-16 Thread 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, >

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-16 Thread ries van Twisk
On Jan 15, 2008, at 11:34 PM, Andreas Becker wrote: > Thanks Ries > > > @ 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 co

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-15 Thread ries van Twisk
On Jan 15, 2008, at 8:01 PM, Andreas Becker wrote: > 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. > >

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-15 Thread 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

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-15 Thread Steffen Kamper
"ries van Twisk" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > > On Jan 15, 2008, at 11:02 AM, Steffen Kamper wrote: > >> <-snip> >>> >>> I guess you will have to "script" that converter on your own, because >>> no >>> "automatic" converter will work with PHP-seri

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-15 Thread ries van Twisk
On Jan 15, 2008, at 11:02 AM, Steffen Kamper wrote: > >>> <-snip> >> >> 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 >>

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-15 Thread Steffen Kamper
"Ernesto Baschny [cron IT]" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Thomas Oppelt wrote: on 12.01.2008 11:43: > http://www.google.ca/search?q=typo3+utf-8 First hit! Then: http://wiki.typo3.org/index.php/UFT-8_support#Convert_an_already_exi

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-15 Thread Thomas Oppelt
Ernesto Baschny [cron IT] schrieb: > Thomas Oppelt wrote: on 12.01.2008 11:43: > 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

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-14 Thread Ernesto Baschny [cron IT]
Thomas Oppelt wrote: on 12.01.2008 11:43: >>> 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

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-12 Thread Thomas Oppelt
ries van Twisk schrieb: > > On Jan 11, 2008, at 3:10 PM, Patrick Gaumond wrote: > >> Thomas Oppelt wrote: >> >>> i would like to know about concepts of migration of a typo3 latin1 >>> database to utf-8. >>> i helped myself by taking a dump and converting it with iconv but that >>> can not solve p

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-12 Thread Thomas Oppelt
Hi Patrick, thanks vor hints, but: is "recode" able to handle serialized strings conversion rather then iconv? Sorry i am not that familiar with both ways. Same question for me according to the wiki example where the dump is not converted at all as i see, just inserted back with --default-char

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-11 Thread ries van Twisk
On Jan 11, 2008, at 3:10 PM, Patrick Gaumond wrote: > Thomas Oppelt wrote: > >> i would like to know about concepts of migration of a typo3 latin1 >> database to utf-8. >> i helped myself by taking a dump and converting it with iconv but >> that >> can not solve problems e.g. caused by serializ

Re: [TYPO3] typo3 database utf-8 conversion

2008-01-11 Thread Patrick Gaumond
Thomas Oppelt wrote: > i would like to know about concepts of migration of a typo3 latin1 > database to utf-8. > i helped myself by taking a dump and converting it with iconv but that > can not solve problems e.g. caused by serialized strings, where > stringlength might differ after conversion.

[TYPO3] typo3 database utf-8 conversion

2008-01-11 Thread Thomas Oppelt
Hi, i would like to know about concepts of migration of a typo3 latin1 database to utf-8. i helped myself by taking a dump and converting it with iconv but that can not solve problems e.g. caused by serialized strings, where stringlength might differ after conversion. is there something known