MySQL datatype for URL's

Question

Possible Duplicate:
Best database field type for a URL

I am in the middle of transferring my access into mysql. My url's were datatype Anchor in the access database and I was wondering what would be the best datatype to store them in mysql

http://stackoverflow.com/questions/219569/best-database-field-type-for-a-url — Ernesto Campohermoso, Oct 26 '11 at 14:12

score 1 · Answer 1 · answered Oct 26 '11 at 14:12

1

I would just go with an appropriately sized varchar.

answered Oct 26 '11 at 14:12

Joe Stefanelli

132,803
19
237
235

score 1 · Accepted Answer · answered Oct 26 '11 at 14:15

1

I would use a generic VARCHAR(255)

http://dev.mysql.com/doc/refman/5.5/en/char.html

answered Oct 26 '11 at 14:15

gawpertron

1,867
3
21
37

MySQL datatype for URL's

2 Answers2