I am facing one starnge problem for the following ,
I have created one small connctivity application in VB.NET. This application fetch the data from the mysql server which is running on the red hat linux machine .
The connection seems to be getting well but when the query executes for the follwoing statement,
Select * from user_groups where limitversion = 'Y';
it gives me the following exception
Message "[MySQL][ODBC 5.1 Driver][mysqld-4.1.7-max-log]Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"
I also tried the same query without any condition as
Select * from user_groups
I t worked excellently . But I want former to work.
Then I tried to chang the character set on both the machines but same problem persists.
Please adivce where should I investigate to get through the problem,