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 |
|
anitha2324
Starting Member
18 Posts |
 Posted - 2008-01-01 : 03:09:20
|
| Dear All,I am using sql server 2000 as my database for my ASP applications , i want to store some ringtones and songs inside the database , i have created table for that , but during the designing of the table i did not find datatype like blob , so what is the way to store songs and ringtones in sqlserver 2000 , is there datatype like 'blob' which allows me to do that , or there is any other option or what is the solution for me problem,please reply me , am newbie to Sql server |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-01 : 03:29:14
|
| SQL Server supports it, however you shouldn't store this type of data in the database. Instead you should store the file on disk, usually at the application server, and then the path to the file in the database.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
anitha2324
Starting Member
18 Posts |
Posted - 2008-01-01 : 03:48:32
|
| Thanks alot for your reply , i ll try that |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
|
|
can sqlserver 2000 supports blob