Avatar of schmucje

asked on 

Select statement row constructor in query browser does not work

I have this select statement that will work with command line, but it will not work in Query Browser.

SELECT * FROM RECIPES.AUTHORS WHERE (FName,LName) = ('joseph','smith');

Error Message: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Any ideas?
MySQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon