[TYPO3-english] Charsets in mysql

[Andreas Becker]

Exactly Marcel - read the Pludin description and also the pages he mentions
from wordpress than you see that it is a very good way to convert it. There
are two more good URF8 Extensions which deal with serialized and massed up
chars - those three together would be fine combined in TYPo3.
Andi

On Wed, Apr 22, 2009 at 12:47 AM, Marcel Remmy <marcel.remmy at fh-kl.de>wrote:

> 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
> >>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>