Results 1 to 1 of 1
Thread: Upgrade from 4.1 to 5.1
Mar 25, 2010, 08:09 #1
- Join Date
- Mar 2010
- 0 Post(s)
- 0 Thread(s)
Upgrade from 4.1 to 5.1
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 '='