New topic: Long Binary to Blob
<http://forums.realsoftware.com/viewtopic.php?t=29417> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message Jason_Adams Post subject: Long Binary to BlobPosted: Wed Aug 05, 2009 8:49 pm Joined: Fri Nov 10, 2006 4:10 pm Posts: 489 I'm working on a project which transfers records from an old database to a new one of a new schema. One old database used the long binary column type to hold a picture blob, and I want to transfer records with said column to SQLite's Blob column. Presently it shows that something transferred, but when I go to convert the data back to a picture it doesn't work. I'm wondering if I can't just transfer the long binary data, to a blob database record, and to the Blob column. it's entirely possible that data is being changed somewhere within the transfer between types. If so I may have to convert the long binary data back to a picture, then convert it again for the blob record. Any thoughts on this? _________________ Vista Home Premium RB Pro 2009r3 "Christianity has not been tried and found wanting; it has been found difficult and not tried." - G.K. Chesterton Top Jonathon Post subject: Re: Long Binary to BlobPosted: Wed Aug 05, 2009 9:08 pm Joined: Fri Sep 30, 2005 5:54 pm Posts: 1929 Location: Great Falls, Montana USA Jason_Adams wrote:I'm working on a project which transfers records from an old database to a new one of a new schema. One old database used the long binary column type to hold a picture blob, and I want to transfer records with said column to SQLite's Blob column. Presently it shows that something transferred, but when I go to convert the data back to a picture it doesn't work. I'm wondering if I can't just transfer the long binary data, to a blob database record, and to the Blob column. it's entirely possible that data is being changed somewhere within the transfer between types. If so I may have to convert the long binary data back to a picture, then convert it again for the blob record. Any thoughts on this?Jason, You might have to create a piece of code that will get the BINARY record and change it to a SQLite BLOB. Just stick it in between either when you get the old data or when you are saving the new data. I have to do that at times as well. HTH. _________________ Jonathon Software Devlopement: http://www.medalertpc.com Surplus Hardware: http://www.semielectronics.com RB2005 R4 Pro for Windows XP Pro/SP2 Top timhare Post subject: Re: Long Binary to BlobPosted: Wed Aug 05, 2009 10:36 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 6009 Location: Portland, OR USA How are you transferring the data? Are you attaching the db and copying en masse? Or are you copying one record at a time, field by field via RB code? Tim Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
