<div>
That led me down the right path. &nbsp;I had changed the server and tables, but the fields still needed to be changed. &nbsp;
</div>


That led me down the right path.  I had changed the server and tables, but the fields still needed to be changed.  

<div>
<div class="content wysiwyg-content">
I have this select statement that will work with command line, but it will not work in Query Browser.<br />
<br />
SELECT * FROM RECIPES.AUTHORS WHERE (FName,LName) = ('joseph','smith');<br />
<br />
Error Message: Illegal mix of collations (latin1_swedish_ci,IMPLICI<wbr />T) and (utf8_general_ci,COERCIBLE<wbr />) for operation '='<br />
<br />
Any ideas?
</div>
</div>


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?

Select statement row constructor in query browser does not work

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.