Page 1 of 3 123 LastLast
Results 1 to 10 of 26
  1. #1
    Join Date
    Mar 2005
    Location
    California
    Posts
    665
    Plugin Contributions
    0

    Default Wrong non-english characters in names/addresses when using paypal express

    Whenever I get orders from places where accented letters are used, they always show up with wrong characters in ZenCart.

    When I check the transactions in my paypal account they show up fine.
    For example:
    The last name Sérudé shows up as Sérudé

    Another example:
    Zürich shows up as Zürich

    What causes this and what can I do to fix it?

    Thanks.

  2. #2
    Join Date
    Jan 2004
    Posts
    60,593
    Blog Entries
    4
    Plugin Contributions
    145

    Default Re: Wrong non-english characters in names/addresses when using paypal express

    I can't reproduce this problem. é and ë come through fine ... showing correctly in customer's My Account area and in ZC Admin area.

    What languages are installed in your site?
    What collation-type is your database using?
    What CHARSET are you using?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.



  3. #3
    Join Date
    Mar 2005
    Location
    California
    Posts
    665
    Plugin Contributions
    0

    Default Re: Wrong non-english characters in names/addresses when using paypal express

    Hi DrByte, thanks for the reply.

    I only have the default English language installed on my site.

    When I log in to phpMyAdmin, I see I have this:

    MySQL charset: UTF-8 Unicode (utf8)
    MySQL collation connection: utf8_unicode_ci

    Should I change any of this?

  4. #4
    Join Date
    Nov 2007
    Posts
    5
    Plugin Contributions
    0

    Default Re: Wrong non-english characters in names/addresses when using paypal express

    Sorry to drag this topic up but I couldn't find any other similar threads.

    I have a similar problem to tj1. I have the same settings:
    MySQL charset: UTF-8 Unicode (utf8)
    MySQL collation connection: utf8_unicode_ci

    Within the database, Collation = latin1_swedish_ci

    Version 1.3.8a by the way. And the Euro currency symbol is processed as a ? in emails if that's relevant to this.

    The last time this happened was when someone used Express Checkout which automatically created their account.
    I've manually created an account and used special characters (ë etc) which are fine.

    I searched for the à symbol in the database and it only occurs in customer related tables (address book, orders, paypal etc). So not in tables where special characters were insert manually--like product description.

    tj1 / DrByte -- do you think it's related to the Paypal Express automatic account creation? Is a fix possible?

    Thanks

  5. #5
    Join Date
    Mar 2005
    Posts
    178
    Plugin Contributions
    0

    Default Re: Wrong non-english characters in names/addresses when using paypal express

    Bringing back this old thread because I'm having the same problem, and it looks like it was never answered.

    When customer accounts are created by hand (for credit card payments), special international characters in their addresses show just fine. However, characters coming from PayPal Express orders are broken.

    For example, in an address:

    av de la République

    Strangely, sometimes the characters work in the shipping address, but not the billing, or vice versa. For instance, on one order, I see this in the shipping address:

    Jean Jaurès

    and this in the billing address:

    Jean-Jaurès

    When I look at the database itself through PHPMyAdmin the bad characters are in there.

    Is there any way to get these characters to translate correctly when PayPal sends them back to Zen Cart?

  6. #6
    Join Date
    Nov 2007
    Posts
    5
    Plugin Contributions
    0

    Default Re: Wrong non-english characters in names/addresses when using paypal express

    Hi aeolidia

    I can tell you I have not fixed this problem. At this time I look at the Paypal email to get the address or hope the custom has edited the address during checkout.

    I can only think it's to do with how Paypal sends the custom data to our database, you will see my post above with UTF-8 and latin1_swedish_ci.
    Would running PHP4 or PHP5 return different results?

    Strangely, sometimes the characters work in the shipping address, but not the billing, or vice versa.
    I have this too, but I think it's because the customer edits it during checkout. Unless you've talked to them and they've told you different?

    Hopefully we can get some more thoughts on this. Anyone had this trouble and solved it?

  7. #7
    Join Date
    Jul 2007
    Posts
    4
    Plugin Contributions
    0

    Default Re: Wrong non-english characters in names/addresses when using paypal express

    Hi,

    same problem here.

    äöüß are translated to not readable symbols.

    I think the data from Paypal has to be decoded, but from what to what ? UFT8->ISO ?

    I hope we will find a solution for this...

    Bye,
    Ingo

  8. #8
    Join Date
    Aug 2008
    Posts
    29
    Plugin Contributions
    0

    Default Re: Wrong non-english characters in names/addresses when using paypal express

    I have same issue Zen Cart 1.3.8a

  9. #9
    Join Date
    Jan 2008
    Posts
    11
    Plugin Contributions
    0

    Default Re: Wrong non-english characters in names/addresses when using paypal express

    I have the same problem.

    Maybe is it possible to change the paypal output charset?

  10. #10
    Join Date
    Aug 2008
    Posts
    29
    Plugin Contributions
    0

    Default Re: Wrong non-english characters in names/addresses when using paypal express

    This problem with special characters or accented fonts is now over 2 years old and still not fully solved.

    There must be a good fix for this bug somewhere?

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. Express Checkout PayPal Style!
    By Citysole in forum PayPal Express Checkout support
    Replies: 10
    Last Post: 25 Jul 2007, 02:11 AM
  2. Paypal Express Checkout - type of account?
    By sfatula in forum PayPal Express Checkout support
    Replies: 5
    Last Post: 10 Jul 2007, 05:22 AM
  3. Paypal Express error 10002 using Sandbox
    By clydejones in forum PayPal Express Checkout support
    Replies: 8
    Last Post: 5 May 2007, 03:12 AM
  4. Difference between Paypal IPN, paypal and express?
    By psr racing in forum General Questions
    Replies: 1
    Last Post: 27 Feb 2007, 01:41 PM
  5. PayPal ...unsupported characters for this field.
    By Peace Freak in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 28 Sep 2006, 05:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •