"Overflow" on insert into table

Hi all.

I'm exporting some legacy stuff from Access to MySQL.
I'm getting an 'overflow' error if I include an Access 'Memo' field. If
I remove it, the query works fine.

The destination field in MySQL is a 'text' field.
The maximum length of data in the Access memo field is 641 characters.

What's overflowing?

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: "Overflow" on insert into table

Daniel,

In my experience, 'overflow' is a fairly generic error message. I have
experienced this when the data you are exporting from MS Access is not
consistent with the definitions of the MySQL table - e.g. null data in a
column defined as NOT NULL, duplicate values in a primary index field, dodgy
date data in Access, or perhaps data that is too loong for the MySQL text
field.

One way to debug this is to switch on the query log in MySQL (add the log
statement in the [mysqld] stanza in my.cnf). When you run the export, you
will see a series of INSERT statements in the log. The last entry in the
log is the last row in the Access table that is OK - i.e. the problem lies
with the data in the row in the Access table immediately following the last
row listed in the log.

Regards,
Martin

-----Original Message-----
From: Daniel Kasak [mailto:dkasak@nusconsulting.com.au]
Sent: 24 June 2005 00:15
To: myodbc@lists.mysql.com
Subject: 'Overflow' on insert into table


Hi all.

I'm exporting some legacy stuff from Access to MySQL.
I'm getting an 'overflow' error if I include an Access 'Memo' field. If I
remove it, the query works fine.

The destination field in MySQL is a 'text' field.
The maximum length of data in the Access memo field is 641 characters.

What's overflowing?

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=martin.kt@nb2bc.co.uk


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org