[
http://mifosforge.jira.com/browse/MIFOS-4150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=61945#action_61945
]
jbrewster commented on MIFOS-4150:
----------------------------------
1.7.x test server result:
mysql> select * from question_group_response where response in (select
CHOICE_TEXT from question_choices where CHOICE_TEXT like "Groupe%");
+-----+----------------------------+-----------------------+-------------------------------------------------------------------+------+
| id | question_group_instance_id | sections_questions_id | response
| tag |
+-----+----------------------------+-----------------------+-------------------------------------------------------------------+------+
| 172 | 25 | 70 | Groupe
électrogene, solaire, lampe à gaz ou électricité (SENELEC) | NULL |
+-----+----------------------------+-----------------------+-------------------------------------------------------------------+------+
1 row in set (0.01 sec)
> question group responses do not preserve accented (UTF-8?) characters
> ---------------------------------------------------------------------
>
> Key: MIFOS-4150
> URL: http://mifosforge.jira.com/browse/MIFOS-4150
> Project: mifos
> Issue Type: Bug
> Components: Surveys/PPI
> Reporter: Van Mittal-Henkle
> Assignee: Jakub Sławiński
> Priority: Critical
> Fix For: Release E - Iteration 11, Release E
>
> Attachments: PPISurveySENEGAL2009.xml
>
>
> Answers to question group questions do not preserve accented characters
> (possibly a problem with preserving UTF-8?). When a question group question
> is answered, the response is copied into the 'response' column of the
> question_group_responses table. The characters that end up in the 'response'
> column do not match the characters from the question_choices.choice_text
> column.
> Attached is a PPI question group with accented characters that can be loaded
> by putting it in the .mifos/uploads/questionGroups folder and then choosing
> to activate the question group for SENEGAL2009.
> An example is when choosing the answer:
> 'Lampe tempête ou lampe a pétrole artisanale'
> it is stored as:
> 'Lampe tempête ou lampe a pétrole artisanale'
> and
> 'Groupe électrogene, solaire, lampe à gaz ou électricité (SENELEC)'
> is stored as:
> 'Groupe électrogene, solaire, lampe à gaz ou électricité (SENELEC)'
> this breaks PPI scoring functionality for surveys with these characters.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues