whats the dataytype we should use to store multimedia file

[agarwalsunitadhn]

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

[vksingh24]

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

[ck9663]

Or just store the path and file name.

-- CK

[agarwalsunitadhn]

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.

[code green]

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?