On Sun, Nov 30, 2008 at 10:52 AM, Jesse Plamondon-Willard < pathoschild(a)gmail.com&gt; wrote: here: http://wikimediafoundation.org/wiki/Donate/Now/en Is me or maybe <form> need charset="*UTF-8*" added to it? withouth it, browser chose the charset to send data from the moon phase. -- -- ℱin del ℳensaje.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 *Comments* are fine. *Donor names* are incorrectly encoded. Tei wrote: Considering that the part that's broken isn't even *on* our form, I'm pretty sure it's not something on our form. :) The name gets put in at PayPal's forms, and is passed on to us with the payment completion data. - -- brion

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Marco Schuster wrote: Assuming it's buggy, perhaps. First we need to confirm simply that PayPal is set to send us UTF-8 data... :) - -- brion

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 mizusumashi wrote: No as it contains private data, but we can check the encoding ourselves once we've gotten in there. - -- brion

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 mizusumashi wrote: Ok, I believe we've tracked it down -- the data came through fine from PayPal, and into our primary databases, but got corrupting during copying from the primary database to the reporting database. The corruption appears to have been due to a temporary variable in the trigger script using the default server encoding (Latin-1) instead of the encoding of the related databases (UTF-8). I've updated the trigger to define the charset on the variable, which should hopefully fix it for new entries, and have rebuilt the reporting database so old entries are now correct. - -- brion

mizusumashi schreef: Mails don't always show up immediately. Also, the archives are grouped per month, so you may have been trying to find e-mails sent in late November in the December archives. Roan Kattouw (Catrope)

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Brion Vibber wrote: Ok, quick summary: 1) PayPal sends us a payment record with 'first_name' and 'last_name' fields. 2) We insert that record into our CiviCRM database. 3) CiviCRM combines the first name and last name into a "display name"... per standard Western ordering assumptions. 4) The display name is copied into our public reporting database and shown on the web. It looks like we can't do much about the name split in 1); that's just what we get out of the payment processor. We may be able to fudge things at step 3) by detecting Han characters and producing a properly-sorted display name, at least for that case. Of course this will still be wrong for Hungarians, and Romanized Japanese names may often get written either way... - -- brion

Bence Damokos schreef: Note that not all people who live in Hungary have Hungarian names, and not all Hungarians live in Hungary. Roan Kattouw (Catrope)

On Wed, Dec 3, 2008 at 10:01 PM, Roan Kattouw &lt;roan.kattouw(a)home.nl&gt; wrote: As there are no such data released (you can't filter donations by currency, or even better currency+location) so I'm just guessing that those donating in forints are mostly (~100%) Hungarians, while there is no easy way to find the Hungarians among those not donating in forints. I didn't want to elaborate on this in my previous mail, but as long as the surname - first name order is not considered wrong, strange or out of place in the context of English, and possibly other languages, than using this order would be a win - win (it would be still acceptable on the English/other interfaces, and on the Hungarian interface it would be correct). However, most Hungarians themselves use the Western order to name themselves in English (and I guess in most foreign languages and contexts) so the Western order would be correct on every interface language (except possibly in those countries that use the non-Western order) except Hungarian (but I dare say that people don't/wouldn't mind it, as they understand that the context is mostly English [website of an American foundation, even the currencies look 'foreign']). In conclusion, I would let the Hungarians' name's rest for this year :). Unfortunately we get the name already divided up from PayPal and are You have a box for comments, that is independent from the PayPal people. Maybe a solution would be to have 3 options instead of two at the privacy checkbox: Display my name [default], Anonymous donation, Display a custom name [this could work possibly for donating in someone other's name, if that's not a privacy concern]. -- Bence Damokos (Damokos Bence in Hungary)

There is something to be said for annoying everyone equally. Being an international organisation is very important for the foundation, it may well be worth annoying (non-Hungarian) westerners unnecessarily in order to show that we're not favouring any nationalities over others. (This is all assuming people that use the Surname-Given name order will actually care - they may all be so used to having their names mangled that they barely notice anymore. A little market research may be called for.)

Brion Vibber wrote: Why? West names would be shown with the 'wrong' order when viewed with the East setting, and viceversa. But it'd be a client setting, so anyone can view the list on the order which fits him most.