Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    31

    Unanswered: Data Type for audio?

    I wanted to save/store a voice message in SQL Server,
    and BLOB is the data type that I'd thought about but
    never been used it. Do you have any best practice or
    suggestion on this subject?

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You need an ActiveX to listen to your audio. The datatype to use on SQL is image. And you can use ADO.Stream to read/write the file.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jun 2003
    Posts
    31
    Thanks rdjabarov,

    If using the Image data type, and since each audio message is only between 9k ~ 18K, is using the text in row (ON) will improve the performance, or the text in row (OFF), which saved the audio file outside of SQL Server is
    better?

    SVT

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You'll benefit from TEXT_IN_ROW only with TEXT data type, when you're storing "clear" text into it. In other words, when you SELECT from a table with this setting on, the optimizer doesn't need to read the pointer value and then go to the BLOB pages to retrieve the actual value of the field. In your case it's a binary file, so you shouldn't bother with this setting.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •