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