hey guys,
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 '='

Any ideas?
Thanks!