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.
On Tue, May 17, 2011 at 09:55, Simos Xenitellis <[email protected]>wrote: > > On Tue, May 17, 2011 at 10:08 AM, Fabien Grenier > <[email protected]>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 >> <[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 >> > > > > -- > 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
