I recently migrated my database from a local environment to a live shared hosting service via cPanel. Everything seems to be working fine, but I encountered an issue when attempting to execute a stored procedure in phpMyAdmin. The error message I received is:

#1271 – Illegal mix of collations for operation ‘concat’

Unfortunately, I do not have the ability to make changes directly to the database. Could anyone provide guidance on how to resolve this issue without requiring modifications to the database itself? Thank you in advance for any assistance.