MySql8 Trailing String comparison
The solutions to this problem is as follows

Added the following to my.cnf

 collation_server=utf8mb4_bin
 skip-character-set-client-handshake


Then in the Connection string I added the following

;old guids=true


I realize this is a hack, but there is a large amount ofstored procedures that compare data such as "where fieldx = 'example'" where the phrase 'example' in the field has trailing spaces.