Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
subduction35
Starting Member
7 Posts |
 Posted - 2005-09-19 : 12:16:45
|
| In the past I had created a database using MS Access for my LP Collection, I have since designed this in SQL Server, the tables are complete.What I have done is created a web front end, after selecting an artist the results are displayed, from the results I would like to be able to play the track or tracks. In the database I have a track table consisting of track id, track title, track no, mp3 track. How can you store MP3 in SQL Server.Many thanks for your helpSubduction35 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-19 : 12:22:26
|
| do not do it. it will bloat your database and complicate certain actions. follow the advice you were already given somewhere else and store the filepath and name of the file in the database.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-19 : 13:00:40
|
| putting the MP3 tracks into your database will also make your MP3s less portable. To move them to your ipod you'd have to extract them from the database first. THat is going to be a PITA.-ec |
|
|
|
subduction35
Starting Member
7 Posts |
Posted - 2005-09-19 : 17:22:32
|
| Thankyou for your response, what would the filepath and name of the file look like in the table. Would it be a varchar or a an image.ThanksRob |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-19 : 17:48:15
|
varcharGo with the flow & have fun! Else fight the flow  |
|
|
|
|
|
|
mp3