Board logo

Anyone know anything about converting JPG to Long Binary data within a dataset?
tegwin - 7/1/09 at 02:43 PM

I need to "import" some JPG files into an access/ MSDB file in Long Binary format...

Anyone know any way of doing it


Mr Whippy - 7/1/09 at 02:52 PM

any use?

linky


vinny1275 - 7/1/09 at 02:53 PM

What language are you using? There must be a library for doing that already- try sourceforge.net if there isn't one built into the language / app you're using - I tend to search it with google though, as its own search doesn't always work well.....

HTH


vince


tegwin - 7/1/09 at 03:35 PM

quote:

What language are you using?



English!!


All joking asside... The data sits in an MSSql database... the images are stored in that database as a link to a physical file..



I have exported from that database a CSV file which contains the usernames and links to their respective photo...

I now need to import that CSV into a piece of software... however it wont accept the links to the file directly it will only accept the images in long binary frmat...

So I dont mind what language I use I just need to change the "photo" field from a file location string to a true long binary...

Make sence... Im confused!


BenB - 7/1/09 at 03:35 PM

Looks tricky to me

http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html


mads - 7/1/09 at 05:39 PM

and i thought i had it difficult with some css drop-down menu code!!

got no advice but good luck!


tegwin - 7/1/09 at 07:18 PM

hmm..fudge

[Edited on 7/1/09 by tegwin]