Improper Collation Virtuemart Conflict

Ok, so we purchased awoaffiliate. When we installed it began to conflict with our virtuemart one page checkout as seen below when users would attempt to complete a purchase: We have used your products before and have not run in to this issue before. Is there anything that can be done on your end to resolve this collation issue involving utf8 unicode and general utf8. It only appears once we have installed your product, awoaffiliate. We have used your awocoupon and aworewards with no issue in the past.

Hello,

Unfortunately it is impossible to determine what the issue is without debugging it directly.  I can do this if you can send a private message with temp admin and ftp access.

That's not really doable. The program is currently uninstalled. The error messages pretty much says that you're awoaffiliate seems to have a set utf8 that is opposite ours.

Hello,

The installation does not choose what utf8 to set, it uses the system default.

On order complete the commissions section is called, the sql code can be found in:
www/administrator/components/com_awoaffiliate/helpers/estore/virtuemart/commissionhandler.php
function commissions_retrieve

There is a utf8 conflict within the tables in the sql query.  So you can compare tables/columns to determine where the issue is.

Okay, Thanks. I'll let you know what we find

---

Turns out that when installed the awoaffiliate becomes active with the wrong charset. Is there anyway to make sure that the right charset is used when the tables are installed or will it need to be done in the database after the fact?

---

Okay,

We resolved the issue.

Ok great.  Just to stress, AwoAffiliate does not set the character set, it allows the system to choose the default.

Yes, We understand. It was just an odd quirk of our database system. Thank you for your help resolving the issue.