Forums » General Discussion

Thread: Import of Blob column

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 0 - Pages: 1 Threads: [ Previous | Next ]
gavvythegunner

Posts: 1
Registered: 1/31/13
Import of Blob column
Posted: Jan 31, 2013 1:20 PM
 
  Click to reply to this thread Reply

I was hoping to use a toad import wizard and subsequently generated template to automate an data import.

I automate the export of a particular table to a .csv file and subsequently import.
This table contains a filed of type blob which is not importing properly
the following error is displayed

1265: Data truncated for column 'colname' row x

The issue may be related to the export of course. Im not sure how to verify that scenario. manually doing this via mysqldump works just fine.

Any help or experiences would be appreciated.


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums