I've got a DTS package that transfers data from an on-line mySQL database to a local SQL Server 2000 database. One mySQL DB field (of collation Latin1-Bin) doesn't get transferred correctly (I've tried a few SQL Server 2000 column collations). Both fields are varchar(255).
Example:
mySQL: W14
MSSQL: 573134
It transfers alphabet characters as their hexadecimal ascii code, and adds "3" before each numeric character.
I can write code to change the MSSQL value to what it should be, although I'd like to know why it's happening (and, if possible, how to stop it from doing this).
Example:
mySQL: W14
MSSQL: 573134
It transfers alphabet characters as their hexadecimal ascii code, and adds "3" before each numeric character.
I can write code to change the MSSQL value to what it should be, although I'd like to know why it's happening (and, if possible, how to stop it from doing this).