By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,286 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

whats the dataytype we should use to store multimedia file

P: 82
Hi
I want to know that what datatype of sql server supports the multimedia files. Here i m using mp3,mpgav and images and i want to store that one in sql server so that i can further access that one
my frontend is ASP.Net
Mar 25 '08 #1
Share this Question
Share on Google+
4 Replies


vksingh24
P: 21
Hi
I want to know that what datatype of sql server supports the multimedia files. Here i m using mp3,mpgav and images and i want to store that one in sql server so that i can further access that one
my frontend is ASP.Net
If you are using SQL Server 2000 ver. use IMAGE data type
Mar 25 '08 #2

ck9663
Expert 2.5K+
P: 2,878
Or just store the path and file name.

-- CK
Mar 25 '08 #3

P: 82
If you are using SQL Server 2000 ver. use IMAGE data type
hi
Thanks.i change sthe datatype to image bt how can i insert the image and sound files to sql.
Mar 27 '08 #4

code green
Expert 100+
P: 1,726
Thanks.i change sthe datatype to image bt how can i insert the image and sound files to sql
I would pay attention to ck9663
Or just store the path and file name.-- CK
Why swell the database with binary files that can be stored in a directory?
Mar 27 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.