Importing Mysql bigint field

Private_Eye

New Member
I've searched and can't find this perviously anywhere.

When I import my recipients from MySQL, one of the fields i need in MaxBulk is a 'bigint (20)' field.

When it's imported maxBulk is truncating this to an 'int' and so most of the records become 2147483647

I get around this by making a copy of my database and converting the offending field to varchar and then MaxBulk imports it ok.

Is there a workaround for this or a fix on the way does anyone know? I tried importing this field as "surname" in the hope that this would always be designated varchar but no luck.

Thanks everyone.

G.
 
Top