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
