Hi EveryBody:

What is the data type that I have to use when I want to save mix data in
database for example photos,music,text fiel,doc file and movies ?

any help will be appreciated regard's

Hi Husam,

Use the 'image' datatype. Image is a binary datatype capable of holding up to 2Gb of data


[quoted text, click to view]



--
Happy coding!

None of the above should be stored in the database IMHO--not until SQL
Server 2008 that introduces the FileStream datatype. For reasons to lengthy
to list here, putting BLOBs in the database (no matter how well SQL Server
handles them) leads to too many other issues to justify their inclusion.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]