GraemeLM
5 months agoTrusted Partner
MySQL Collation for Local Instance
Does anyone know the correct configuration for a local instance of MySql? I've followed the academy guide for MySql which didnt include any collation changes.
When joining my custom field X.SOOrderType to SOOrder.OrderType I get an illegal mix of collation error.
Not sure if my instance is configured incorrectly, or what I should be doing to replicate the MYOB platform.