Associating Images, Video, Audio to Records in Table

[shms]

Dear Support,

Greetings!

I'm registered with Bluevoda and my website is: www.seetharamhospital.com

I'm creating database and tables - just wondering is it possible to associate (or store) media like Images, Audio, Video with records.

What should be the field type for the same.

Any insight will be very helpful.

Thanks much.

Regards,
Ram

[VodaHost]

Re: Associating Images, Video, Audio to Records in Table

Hi,

It is possible but it is not recommended to store images or video into a database. Usually you would store these in a folder on your account and then make a link from the database to the folder for loading. This cuts down on database size and makes loading faster.

The field type should be LONGBLOB for all.

[shms]

Re: Associating Images, Video, Audio to Records in Table

Great.
Thanks much for the advice..
As suggested, I will upload the media in the folder and provide a link where ever needed.

[VodaHost]

Re: Associating Images, Video, Audio to Records in Table

Hi,

You're welcome!