October 13, 2005 at 12:48 pm
What I'd like to do is to store a recording file (.vox extension) along with a record inside of SQL server.
I know I've seen pictures being imbedded into tables within SQL but can't think of what search terms to use to see if I can try to modify it for what I'm trying to do.
Does anyone have an answer for me or is this something that atypically isn't done?
Thanks in advance.
October 13, 2005 at 1:12 pm
I think what you are looking for is what is called "Steaming". I have done this in the past with word documents, excel spreadsheets and images, but I am nto sure if this can be done with audio files. Here is a link to an article that reviews how to store image files.
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=105&rl=1
October 14, 2005 at 7:35 am
Hi. Yeah, it is "streaming" - you can store anything you like up to 2GB in a single record. It could be any binary data at all, needn't be a certain type of picture, document or file. You store them in what is known as an "image" field, but that term doesn't refer to pictures, it is an image in the same way that a .iso file is known as a "CD Image".
However, you'll need support in your client side database library to get the data into and out of SQL. If you have worked with memory streams or file streams, you can effectively get what you would call a BLOB (binary large object) stream. If you can let us know what client side library & development tool you are using we can probably offer some better advice.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply