I managed to solve the issue, Ken, thank you for the reply
it was a database collation issue
Hi Leah -
I'm running into the same issue for a migration. Can you provide any details on how you fixed it? Specifically was it relatively a few steps or do I need a SQL developer? I'm a VA and am transferring for a client. I'm a programmer but not focused on that right now.
Thanks.
Denice
Hi Denice
You have to open your database sql file and replace character set utf8mb4 with utf8
It worked for me
I hope it will work for you as well