No subject

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.f=
r
> 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 =C3=A9crit :
> > 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 dat=
a
> > 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) an=
d
> > 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 hav=
e
> 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 w=
as
> >>>> 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
>