So, I had our IT guy come in to assist. He did some investigation and said that “it was a collation mismatch in mysql 5.8”. I don’t understand it, but that seems to have fixed our problems. Just sharing in case this issue arises for others.
Cheers