Oracle BLOBS are binary, not text - they are going to break if you put them in a text field. Are you sure you don't mean CLOBs?
On 8/11/06, Lars Gronholt <[EMAIL PROTECTED]> wrote: > I'm just wondering if anyone knows of a way to detect a if a field selected > from an Oracle database is a BLOB? (using CFMX 6.1) My problem is that we are > trying to migrate a database over to MySQL from Oracle and due to a lack of > inexpensive migration tools (I'd be perfectly happy to be proven wrong here!) > since it's a one-off, and a freebie for a long term client. > > Anyway, one of my co-workers got the table strcutures duplicated into MySQL > using some arcane ritual, but of course it's left the primary key info etc > behind, that's all fine , but we couldn't migrate the data itself. We've > tried several tools to no avail, so I bit the bullet and wrote a quick CF > file that accepts a list of tablenames, loops through them and selects > everything from each table - loading that info row-by-row into form variables > which have the same name as the columns from that table, I'm then triggering > a cfinsert of this info into the MySQL version of the DB before moving onto > the next row etc... > > The problem is this: It works like a charm, isn't even that slow considering > the volume of data, BUT, any Oracle BLOBs take on a random bit of garabge at > the start of their chunk of data as they're inserted into MySQL TEXT fields, > they're fine when they get assigned to the form variable for them - I've > output this value and checked it, it must be happening during the cfinsert - > I'm just wondering if there's any way I can encode them first? or do we need > to go through the MySQL db before running the import and change the TEXT > fields to something else? > > Any help is much appreciated! And sorry for the novella! > > Aegis > -- www.legalwarfare.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249530 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
