[walkman]

Ok, it's a bit of a hassle but I was able to solve the problem by doing the following:

1) export the table as a batch script from the source database

2) switch to the target database

3) open the batch script

4) Edit out the “default charset=latin1” reference in the SQL create statement

5) Run the script

Obviously, this isn't effective for an on-going syncronization, but it works on an occasional basis.

Please let me know if there is a better “fix”.

[Author]

Posts