openlp-core team mailing list archive

[Mike Robinson <744596@xxxxxxxxxxxxxxxxxx>]

I had this exact problem on Debian with Chinese characters. They were
all showing up as question marks (????) when saving online through
pootle or uploading a file that was translated offline. I ran the
command listed here: http://www.commandlinefu.com/commands/view/1575
/convert-all-mysql-tables-and-fields-to-utf8 and it worked. If your
mysql has a root password (which it hopefully does) you can alter it
like this:

mysql --database=pootle -B -N -e "SHOW TABLES" -pyour_password | awk
'{print "ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE
utf8_general_ci;"}' | mysql --database=pootle -pyour_password

Then log out and back in and delete that line from your ~/.bash_history
file.

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/744596

Title:
  [pootle] locale encoding errors

Status in OpenLP - Worship Presentation Software:
  Fix Released

Bug description:
  When working on openlp czech translation it is possible to save
  translated string containing localized characters, however instead
  some localized characters the char '?' (question mark) is displayed.
  I'm not able to edit already entered text without the need to correct
  all '?' with proper character.

  Example - correct text
  ----------------------------------
  Tato aplikace je šířena v naději, že bude užitečná, avšak BEZ JAKÉKOLI ZÁRUKY; neposkytují se ani odvozené záruky PRODEJNOSTI anebo VHODNOSTI PRO URČITÝ ÚČEL. Další podrobnosti viz níže.

  
  Example - bad text
  -----------------------------
  Tato aplikace je ší?ena v nad?ji, že bude užite?ná, avšak BEZ JAKÉKOLI ZÁRUKY; neposkytují se ani odvozené záruky PRODEJNOSTI anebo VHODNOSTI PRO UR?ITÝ Ú?EL. Další podrobnosti viz níže.

  
  If necessary I would love to assist in resolving this bug.

  I'm not sure if it is an issue of pootle or of my browser (chrome)

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/744596/+subscriptions