Donator names are not stored with the proper charset
Donators' names are not stored with the proper charset. For example, on http://pledgie.com/campaigns/2975/detail, the name "Guillermo Alcántara" shows up as "Guillermo Alc�ntara". Saving the HTML file to disk and changing the content-type tag to iso-8859-1 made the browser display the names properly. This seems to imply that the names are stored in your database as iso-8859-1 instead of UTF-8, as they should be.
Support Staff 2 Posted by Garry Dolley on 22 Feb, 2009 11:16 PM
No, we've tried storing names at UTF-8 and while it fixes some names, others then break (that were working before).
I suspect PayPal is providing names in different character sets, depending on the locale of the user.
We need to detect the charset (which is provided), convert it to UTF-8, and then save that.
This is in our TODO list.
3 Posted by hongli on 22 Feb, 2009 11:41 PM
A Paypal IPN has a parameter called "charset", maybe that's what you're looking for?
Support Staff 4 Posted by Garry Dolley on 23 Feb, 2009 12:10 AM
I am aware of the "charset" parameter (I said "which is provided"). We need to convert from the charset to UTF-8 and save that. It is on our TODO list.
5 Posted by qubodup on 09 Jun, 2009 09:56 PM
another example: http://pledgie.com/campaigns/4045 : donator #5 has an unknown symbol in his name. I assume it should be "ö"