utf-8 issue with "Ismaël

[Pierre Buyle]

From: Marc Portier <email address hidden>
  * I've seen there is some utf-8 issue with "Ismaël"

  > var infoTabs196_196 = [ new GInfoWindowTab('Supporter', 'Ismaël, expert<br/>Waalshoekstraat 43, Desselgem<br/>I speak Dutch.<br/>Ask me for:<br /><ul><li><a href=\"http://ubuntumapbeta.lusis.be/beta/index.php/supporters/contact/196/distribute\">a free Ubuntu install set</a></li><li><a href=\"http://ubuntumapbeta.lusis.be/beta/index.php/supporters/contact/196/demo\">a free Ubuntu demonstration</a></li><li><a href=\"http://ubuntumapbeta.lusis.be/beta/index.php/supporters/contact/196/install\">free help with your first install</a></li></ul>')]
  > var marker196_196 = new GMarker( new GLatLng(50.8881, 3.3841) );
  > GEvent.addListener(marker196_196, "click", function() { marker196_196.openInfoWindowTabs(infoTabs196_196); });
  > map.addOverlay(marker196_196);

  * to check if this isn't related to old test data in the system I tried to add a new user to the system:
  * during that phase I violated some valdation rules (password too short, non belgian zipcode (?)...) and I must say some RED indicating
what and where the error is should help allong with some general feedback THAT THERE IS AN ERROR
  * ultimately I don't get any more validation errors reported, but still I fail to register this new guy named "Iñtërnâtiônàlizætiøn Test" (I don't get email, I don't get to see the new peep, I don't get a form-submit feedback that talks about "SUCCES")

  By the way, for some general advise on i18n, and the good test-string, see http://www.intertwingly.net/stories/2004/04/14/i18n.html

[Pierre Buyle (mongolito404)]

 * "Ismaël" is not an error during importing data since e registred on the 2007-05-01 (according to the database).
 * Errors in form fields during registration and edition are displayed but not in red. The red color is useful and will added together with a simple error message on top of the form.
 * I will look at the "Iñtërnâtiônàlizætiøn Test" registration later.
 * Concerning the confirmation code, as (badly) explained at the top of the password lost page, password recovery is a two steps process. First fill only the email field, if a supporter with that email is registered, an email with the confirmation code is sent. Then, fill both fields and a new password will be sent.

[Marc Portier (marc-portier)]

To keep this issue clean and focussed on the i18n issue, I have split the other reported things in separate issues:

* provide better validation feedback:
    https://bugs.launchpad.net/support.points.map/+bug/102271

* provide better wording / flow for the password recovery procedure
    https://bugs.launchpad.net/support.points.map/+bug/102267

[Marc Portier (marc-portier)]

To keep this issue clean and focused on the i18n issue, I have split the other reported things in separate issues:

* provide better validation feedback:
    https://bugs.launchpad.net/support.points.map/+bug/102271

* provide better wording / flow for the password recovery procedure
    https://bugs.launchpad.net/support.points.map/+bug/102267

[Pierre Buyle (mongolito404)]

On my local installation, I don't have the (i18n) problem after setting database/table/column encoding to UTF-8 (default was latin1_swedish_ci).
But the MySQL at the beta site doesn't seems to support database/table/column encoding, so there must be another option to solve this problem.

[Pierre Buyle (mongolito404)]

I successfully registred at the beta site with "Iñtërnâtiônàlizætiøn" as first name without any code change.
See http://ubuntumapbeta.lusis.be/beta/index.php/supporters/details/203

[Pierre Buyle (mongolito404)]

I double checked, "Ismaël" registred (at the beta site) on the 2007-05-01, that before the launch of the beta. So the encoding error is more likely an error during the import.

Without any reports about this issue in the next week, the bug will be rejected.

[Marc Portier (marc-portier)]

sure, fine I just noticed and reported.
You checked and verified, I'm not in a position to question your outcome.