How to store audio files in sqlserver 2000?
-
How to store audio files in sqlserver 2000? i want to store all mp3 files in sqlserver and want to retrieve them from the database , so that i can play them one by one , can anyone tell me the code for this task ? please suggest me the logic or any code for this help me out
-
How to store audio files in sqlserver 2000? i want to store all mp3 files in sqlserver and want to retrieve them from the database , so that i can play them one by one , can anyone tell me the code for this task ? please suggest me the logic or any code for this help me out
As audio file is big enough you can store as VARBINARY type which stores as binary data if VARBINARY is available in SQL SERVER 2000(VARBINARy is avaiable in sql server 2005). As I am working using sql server 2005 please check what is equivalent to VARBINARY of SQl server 2005 in SQL server 2000.
Thanks, Arindam D Tewary
-
How to store audio files in sqlserver 2000? i want to store all mp3 files in sqlserver and want to retrieve them from the database , so that i can play them one by one , can anyone tell me the code for this task ? please suggest me the logic or any code for this help me out
-
How to store audio files in sqlserver 2000? i want to store all mp3 files in sqlserver and want to retrieve them from the database , so that i can play them one by one , can anyone tell me the code for this task ? please suggest me the logic or any code for this help me out
Although i would recommend u not to store audio files in sql, rather u should store them in ur file system, I guess you need to store them in sql as BLOB type ie in a byte stream. While fetching it from sql again u have to convert again this byte stream to ur suitable format(audio).