Byte fields not handled properly

General usage of Access to MySQL

Moderator: jr

Byte fields not handled properly

Postby 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
Pegsneggle
 
Posts: 3
Joined: Thu Oct 23, 2008 12:10 pm

Return to General

Who is online

Users browsing this forum: No registered users and 1 guest