[ 
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

Reply via email to