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. Bye Fabien On Mon, May 16, 2011 at 16:09, Simos Xenitellis <[email protected]>wrote: > > On Mon, May 16, 2011 at 4:46 PM, Fabien Grenier > <[email protected]>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 <[email protected] >> >wrote: >> >> > >> > >> > On Mon, May 16, 2011 at 9:07 AM, Fabien Grenier < >> [email protected]>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 >> [email protected] >> 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 [email protected] https://lists.sourceforge.net/lists/listinfo/translate-pootle
