On 2011-05-17 10:37, Fabien Grenier wrote: > You are right I may skipped this point because I didn't see "MySQL" is a > link and I missed the charset info. Perhaps you should add a little warning > in the optional software table in the main installation page near the MySQL > link. Fabien, at the moment you are the expert :) Would you mind updating the wiki if it can save someone else from your issue. Just pasting your instructions would help someone who needs to recode the DB. > > On Tue, May 17, 2011 at 09:55, Simos Xenitellis > <simos.li...@googlemail.com>wrote: > >> On Tue, May 17, 2011 at 10:08 AM, Fabien >> Grenier<fabien.gren...@rtone.fr>wrote: >> >>> Hello all, >>> >>> I find the problem, my MySQL DB was in lantin1 (ISO 8859) and it seems to >>> be >>> a problem for Pootle, I don't understand why because all my text files are >>> in UTF-8. >>> >>> So here is a solution : >>> - Backup your DB : mysqldump pootle -upootle -p >>> --default-character-set=latin1 --skip-set-charset --flush-logs >>> --lock-all-tables> dump_pootle.sql >>> - change encoding of your dump file : sed -r 's/latin1/utf8/g' >>> dump_pootle.sql> dump_pootle_utf.sql >>> - reencoding your dump : recode latin1..utf8 dump_pootle_utf.sql >>> - Delete your iso DB and create a UTF-8 DB : mysql -upootle -p >>> --execute="DROP DATABASE pootle; CREATE DATABASE pootle CHARACTER SET utf8 >>> COLLATE utf8_general_ci;" >>> - Import your UTF-8 dump in your new pootle DB : mysql -upootle -p >>> --default-character-set=utf8 pootle< dump_pootle_utf.sql >>> >>> After that, my pootle works correctly (I just lost "€") and I can insert >>> greek. >>> >>> I hope that could be usefull if anyone encounter this issue. I think that >>> Pootle doc should include a warning about this point because latin1 is >>> default charset for MySQL. >>> >> Did you initially follow the instructions found at >> http://translate.sourceforge.net/wiki/pootle/mysql ? >> Should these instructions be updated with explicit reference to collation >> as well? >> >> Simos >> >> >>> Bye >>> Fabien >>> >>> On Mon, May 16, 2011 at 16:09, Simos Xenitellis >>> <simos.li...@googlemail.com>wrote: >>> >>>> On Mon, May 16, 2011 at 4:46 PM, Fabien Grenier< >>> fabien.gren...@rtone.fr>wrote: >>>>> My PO files are in UTF-8 so I have to find another way to explore. >>>>> >>>>> >>>> Also check whether the webserver enforces an encoding other than UTF-8. >>>> You can verify with 'wget -S http://myurletc.com'. >>>> >>>> Typically when you mention 'Greek encoding' or any other encoding such >>> as >>>> Cyrillic, etc, >>>> you talk about the legacy 8-bit encodings such as iso-8859-7 (Greek). >>>> These are not used anymore, and for whichever language you want, you >>> would >>>> just set it to UTF-8. >>>> >>>> So, if you asked your web administrator for 'Greek Encoding', they may >>>> simply enforced iso-8859-7, >>>> which could be the cause of your problems. >>>> >>>> Simos >>>> >>>> >>>>> On Mon, May 16, 2011 at 15:41, Chris Leonard<cjlhomeaddr...@gmail.com >>>>>> wrote: >>>>>> >>>>>> On Mon, May 16, 2011 at 9:07 AM, Fabien Grenier< >>>>> fabien.gren...@rtone.fr>wrote: >>>>>>> Hi Chris, thanks for your answer. >>>>>>> >>>>>>> Unfortunately I don't think it's a font problem. Indeed I can see >>> greek >>>>>>> letters in my computer (I see your pootle without problem) and I try >>> to >>>>>>> insert greek text in pootle (got with google traduction). I see that >>>>> the >>>>>>> http post request contains the greek text but the http response >>>>> contains >>>>>>> "????". I think it's a bad config of Pootle or perhaps Django. Did >>> you >>>>> do >>>>>>> anything about encoding stuff when you installed pootle ? >>>>>>> >>>>>>> >>>>>> I didn't do the install, so I can't say. The other thought that >>> occurs >>>>> to >>>>>> me is to check the POT to see what it's encoding is (e.g. UTF-8 or >>>>> what). I >>>>>> may not be able to help you as much as the other people on this list, >>>>> but I >>>>>> thought I'd try to rule out some of the simpler error types. >>>>>> >>>>>> cjl >>>>>> >>>>> >>> ------------------------------------------------------------------------------ >>>>> Achieve unprecedented app performance and reliability >>>>> What every C/C++ and Fortran developer should know. >>>>> Learn how Intel has extended the reach of its next-generation tools >>>>> to help boost performance applications - inlcuding clusters. >>>>> http://p.sf.net/sfu/intel-dev2devmay >>>>> _______________________________________________ >>>>> Translate-pootle mailing list >>>>> Translate-pootle@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/translate-pootle >>>>> >>>> >>>> >>>> -- >>>> A. Because it breaks the logical sequence of discussion >>>> Q. Why is top posting bad? >>>> >>> ------------------------------------------------------------------------------ >>> Achieve unprecedented app performance and reliability >>> What every C/C++ and Fortran developer should know. >>> Learn how Intel has extended the reach of its next-generation tools >>> to help boost performance applications - inlcuding clusters. >>> http://p.sf.net/sfu/intel-dev2devmay >>> _______________________________________________ >>> Translate-pootle mailing list >>> Translate-pootle@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/translate-pootle >>> >> >> >> -- >> A. Because it breaks the logical sequence of discussion >> Q. Why is top posting bad? >> > ------------------------------------------------------------------------------ > Achieve unprecedented app performance and reliability > What every C/C++ and Fortran developer should know. > Learn how Intel has extended the reach of its next-generation tools > to help boost performance applications - inlcuding clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Translate-pootle mailing list > Translate-pootle@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/translate-pootle
-- regards Dwayne ------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Translate-pootle mailing list Translate-pootle@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/translate-pootle