Hi, what is the best data type to store Urls?.
I need save on database file system path for pictures.
thanks
sorry, why not use char instead? thanks
GIbboK
2010-07-28 08:54:42
CHAR should be used for storing fix length character strings. String values will be space/blank padded before stored on disk. If this type is used to store varibale length strings, it will waste a lot of disk space.
Michael Pakhantsov
2010-07-28 09:28:05
thanks i understand now
GIbboK
2010-07-28 11:05:41
+2
A:
varchar. Choose a suitable max length based on your domain knowledge.
Neil Barnwell
2010-07-28 08:53:07
@GibboK: Because you would be wasting a lot of space using `char`. Unlike the fixed-size `char` data type, `varchar` does not store any blank characters when the full length of the field is not used.
Daniel Vassallo
2010-07-28 08:54:59
varchar because the db can trim unused space, unless all your URLs are going to be the same length.
Adam
2010-07-28 08:55:30
+3
A:
URLs are strings and will be of variable lenghts.
If your database system supports this, use VARCHAR.
Oded
2010-07-28 08:53:22
+2
A:
We tend to save them as urlencoded VARCHARs. (Since our URLs are coming to the database from a server, we encode them using PHP's urlencode and then decode them when we retrieve them with urldecode.) Don't think there's really much else that needs done - you could probably just store them as unencoded VARCHARs.
Stephen
2010-07-28 08:54:36