I am making the switch from mysql 4.1 to 5.1.
Now i'm in the testing mode.I'm stock at some point.
Thi is the query where it gets stock.
"select Max(ID_Synchro) from DateSynchro where ID=" & id
This query gets the last synchronization date from a remote server and brings it back to the local computer.
In the remote server I have MySQL 4.1 and my local computer I have 5.1
if I use a local computer with mysql 4.1 it works well, once i do that query with 5.1 it gives the next error.
I get the error illegal mix of collation (latin1_swedish_ci,IMPLICIT) and
(UTF8_general_ci,COERCIBLE) for operation '='