1 Replies - 541 Views - Last Post: 07 January 2010 - 05:59 AM Rate Topic: -----

#1 mahecs26  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 07-January 10

Handling multimedia files inSQL server

Posted 07 January 2010 - 02:54 AM

hi
whether the SQL server store the vidoe files


plz ans me


Thanks,

Regards,

Mahendran K

(volunteer of "GREEN WORLD"

Donate as ur wish after seeing
Is This A Good Question/Topic? 0
  • +

Replies To: Handling multimedia files inSQL server

#2 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 6078
  • View blog
  • Posts: 23,548
  • Joined: 23-August 08

Re: Handling multimedia files inSQL server

Posted 07 January 2010 - 05:59 AM

Save video files OUTSIDE of the database, saving a link to them in the database, like this pseudocode:
CREATE TABLE videos 
(
	id INT PRIMARY KEY AUTOINCREMENT,
	description VARCHAR(256),
	path VARCHAR(2048)
);

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1