Hi everyone, just wanted to know what type should i use in mysql database to store the urls (for linking purposes) of videos(from youtube,vimeo) and slides (from slideshare)...i just want to store the urls not the whole video..for tht i wud use directory/ file functions.. please help... helpful comments will be appreciated :)

4 Years
Discussion Span
Last Post by Riu 2009

thnakyou so much
any other thing that should be mentioned while saving these types of fields in mysql?? actually iam new to mysql n php so dont have an idea what else should be used.. tanhks in advance :)


@smantscheff -
I did wonder whether to suggest a longer length, but the likelihood of a URL being that long is very unlikely in my opinion.

@Rui_2009 -
My only other suggestion would be to not include the host name in the URL for files hosted on your server. This will make it easier to move between development, staging and live environments.

For Youtube, Vimeo URLs, etc, you'll obviously need the full URL.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.