Amazon Payment Addresses

[jnsgioia]

I have noted this before, but have just had the time to explore it in some detail. The Amazon Payment module in guest checkout saves the address to manufacturers. If you go into the order and edit the shipping address there is a 0 in the email field. If you put the customer's email address in the field and save the address an address is created in the proper place in Addresses. I checked the database and all the Amazon tables have a Type: MyISAM and Collation: latin1swedishci. The rest of the tables have Type: InnoDB and Collation: utf8mb4unicodeci. Should I change the Amazon tables Type and/or Collation?

[alwayspaws]

I opened a separate forum post in case this needs further looking at for other database issues:

https://forum.thirtybees.com/topic/463/database-table-entries-collation-latin1swedishci-instead-of-utf8mb4unicodeci

[alwayspaws]

Ok for me.

[jnsgioia]

So should I change the Type and Collation or will that mess up things worse?

[alwayspaws]

Here are screenshots of what I did for guest checkout but I'm not sure if this is what you're looking for.

and

and