Project

General

Profile

Bug #1802

Encoding issues

Added by Olivier CORRE over 9 years ago. Updated about 9 years ago.

Status:
Feature implemented
Priority:
Normal
Category:
-
Target version:
Start date:
03/08/2010
Due date:
% Done:

100%

Estimated time:
Complexity:
Challenging
SCRUM pts - complexity:
?

Description

This has already been documented in this thread (http://chamilo.org/fr/node/664). I'm not entirely sure whether this bug is limited to my host or not. Indeed, text in Chinese entered manually in the database will show properly in annoucements/private messages/front page text. As soon as i try to edit the text from within the interface, it reverts back to ???. By editing, i mean simply opening the annoucement in the editing page (without saving) will break the encoding!

However, links and title page/site name in Chinese can be edited and displayed well (see attachment).


Files


Related issues

Related to Chamilo LMS - Bug #1734: Encoding problem in "news" (Chinese characters don't show)Feature implemented15/07/2010

Actions

History

#1

Updated by Ivan Tcholakov over 9 years ago

Under #1734 I tried to reproduce the bug, but without success, there is no enough information.

#2

Updated by Olivier CORRE over 9 years ago

i keep investigating and will post if i find any new info.

#3

Updated by Olivier CORRE about 9 years ago

i have fixed this issue (at least on my website) by replacing lines 179 and 180 in global.inc.php with the folowing:

Database::query("SET CHARACTER SET 'utf8';");
Database::query("SET NAMES 'utf8';");

#4

Updated by Olivier CORRE about 9 years ago

please close. tks!

#5

Updated by Ivan Tcholakov about 9 years ago

  • Status changed from New to Assigned
  • Assignee set to Ivan Tcholakov
  • Target version set to 1.8.8 alpha
  • % Done changed from 0 to 10

This task is not to be closed yet. I am going to propose a permanent patch.

#6

Updated by Ivan Tcholakov about 9 years ago

12420:c2fbf1a49673 Bug #1802, Chinese & UTF-8 - A proposal for a patch about a specific database encoding problem.
http://code.google.com/p/chamilo/source/detail?r=c2fbf1a4967322e5c655ec7243f445c88cecb858&repo=classic

Dear Oliver, could you try the proposed change?

#7

Updated by Olivier CORRE about 9 years ago

thanks Ivan for taking time to look inot the matter. i almost gave up.
anyways, confirmed working ok on my side with both simpl and trad Chinese. it's been a while i was looking forward to nail this one :-)

#8

Updated by Ivan Tcholakov about 9 years ago

  • % Done changed from 10 to 80

12422:a8e66fb2ac70 Bug #1802 - Applying the database encoding patch for the custom php session handler too, this is for the case when database is used for storing php session variables.
http://code.google.com/p/chamilo/source/detail?r=a8e66fb2ac7053bb2502fc78c1a089994eb9d931&repo=classic

12421:3eae77eaa398 Bug #1802 - A comment has been added.
http://code.google.com/p/chamilo/source/detail?r=3eae77eaa398e346f160d7181d6e772079d6c86c&repo=classic

#9

Updated by Ivan Tcholakov about 9 years ago

  • Status changed from Assigned to Feature implemented
  • % Done changed from 80 to 100

12423:0236abb98404 Bug #1802 - Updating changelog.html.
http://code.google.com/p/chamilo/source/detail?r=0236abb984040a62e6c100b74eb32b8fa98fe436&repo=classic

Ok, I am closing this task.

#10

Updated by Olivier CORRE about 9 years ago

there was definitively a bug in the way Chamilo sets the tables' encoding (maybe under certain specific conditions which remain unclear to me). I had to convert parts of my db to utf8.

thanks Ivan!!! thumbs UP!!!

Also available in: Atom PDF