[TYPO3-english] Charsets in mysql

[Marcel Remmy]

hey andreas,

that is a, let me say, unconventional way to convert one cms with
another one ;) but hey, as long as it works out... great! thanks for the
tip.

but then one could inspect this mentioned bbwp2utf plugin further and
suck out code that would make perfectly out as TYPO3 extension, right?

just my 2 cents,

marcel


Andreas Becker wrote:
> Hi Tomaz
> Today we converted a TYPO3 multilingual site to utf8 with over 3600 Pages
> 
> Install newest Wordpress in your TYPO3 database - it will add 10 more tables
> 
> Next you install the Plugin bbwp2utf8.1.0 (has very good description what it
> is doing)
> Call it
> If it get stuck than don't worry - simply check your database where it got
> stuck. - TIP compare the field settings to figure out which table hasn't bee
> set to binaries
> 
> instead click again on the plugin Icon and start again but SKIP the tables
> which are already set to binaries. keep on going until you get ported to
> step two.
> 
> From here usually it just walks thru and finally you have utf8_general_ci
> all over
> 
> It took us 30 Minutes incl install of wordpress, plugin and the conversion.
> 
> Have fun
> 
> Andi
> 
> 
> On Tue, Apr 21, 2009 at 11:09 PM, Damien Sauveron <damien.sauveron at unilim.fr
>> wrote:
> 
>> I do not know if it can help:
>>
>> http://xavier.perseguers.ch/en/tutorials/typo3/configuration/utf-8.html
>>
>> Best regards,
>> Damien
>>
>> Marcel Remmy a écrit :
>>> hey tomaz,
>>>
>>> sorry if i mainly say the same like andreas, but my advice is to not go
>>> the path where you patchwork your database with all kinds of encodings.
>>> go for clean utf-8 which is no hype or something, it's just the way data
>>> should go nowadays.
>>>
>>> the tool you need for is a small command line tool called recode or
>>> iconv, if you are on a linux shell.
>>>
>>> you mention the template (sys_templates) that won't be encoded
>>> correctly. here is how i got rid of the exact same problem:
>>>
>>> export your sys_template sql (convently with a tool like phpmyadmin) and
>>> make sure you export blob not in hex but in binary. this way your
>>> template setup and constants are recoded as well.
>>>
>>> then change your collation stuff and import the now recoded file again.
>>> worked for me.
>>>
>>> good luck,
>>>
>>> marcel
>>>
>>>
>>> Tomaz Zaman wrote:
>>>> Tried that, but i don't think i have the right tools for that.
>>>>
>>>> And other things get broken if i do that (templates mainly)
>>>> That said i would only need to convert fe_users, pages, and tt_content
>>>> tables, but as i said, the tools i found only change charsets and
>>>> collations, but none actually convert the data
>>>>
>>>> Tomaz Zaman
>>>>
>>>> Andreas Becker wrote:
>>>>> Hi Tomaz
>>>>> Why don't you convert the complete database instead of doing work
>>>>> piece by
>>>>> piece. You will always again get to the point where it would be good
>>>>> to have
>>>>> a clean utf8. It is at least worth a try, don't worry about the size to
>>>>> much.
>>>>>
>>>>> Andi
>>>>>
>>>>>
>>>>> On Mon, Apr 20, 2009 at 8:08 PM, Tomaz Zaman <tomaz at optiss.si> wrote:
>>>>>
>>>>>> Hey
>>>>>>
>>>>>> I made an extension that list FE users, all went well, but now i have
>> a
>>>>>> small problem, I need to fetch users from database, but i would like
>> to
>>>>>> use 'SET NAMES utf8' ONLY(!!!) when querying for fe_users.
>>>>>>
>>>>>> Is that possible?
>>>>>>
>>>>>> (I made a mistake in not putting 'SET NAMES utf8' when the website was
>>>>>> set up, now it is about 3GB big, so i cannot manually fix characters -
>>>>>> the only ones that can be updated are fe users, because i get them
>> from
>>>>>> an LDAP server)
>>>>>>
>>>>>> Tomaz Zaman
>>>>>> _______________________________________________
>>>>>> TYPO3-english mailing list
>>>>>> TYPO3-english at lists.netfielders.de
>>>>>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>>>>>>
>>> _______________________________________________
>>> TYPO3-english mailing list
>>> TYPO3-english at lists.netfielders.de
>>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>>
>> _______________________________________________
>> TYPO3-english mailing list
>> TYPO3-english at lists.netfielders.de
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>>