Byte fields not handled properly

Pegsneggle · Post by **Pegsneggle** » Thu Oct 23, 2008 1:01 pm

A byte sized field in Access is unsigned and allows numbers between 0 and 255. When the transfer to mySQL takes place, the result is a signed tinyint(3). This has a range of -127 to +127 or thereabouts. So if any of the original data has a value between 128 and 255 it is rejected and data transfer for that table stops immediately.

I got round this by just importing the table structures, fixing the field problem, then importing the data. Can this be fixed?

Thanks