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.comwrote:
On Tue, May 17, 2011 at 10:08 AM, Fabien
Grenierfabien.gren...@rtone.frwrote:
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.comwrote:
On Mon, May 16, 2011 at 4:46 PM, Fabien Grenier
fabien.gren...@rtone.frwrote:
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 Leonardcjlhomeaddr...@gmail.com
wrote:
On Mon, May 16, 2011 at 9:07 AM, Fabien Grenier
fabien.gren...@rtone.frwrote:
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?
--