What's the proper column type to save urls in MySQL?

I've been using varcha开发者_运维问答r(300),but I've also noticed longer urls.

---

Use TEXT, it's enough for every URL.

Note that with long URLs, you won't be able to create an index that covers the whole URL. If you need a UNIQUE index, you should calculate the URL hash, store the hash separately and index the hash instead.

---

Technically HTTP does not put a limit on the max length of a URL. Read this SO post.

So varchar will not be of help, You'll have to use TEXT

---

As of now:

<< MySQL 5.0.3 use TEXT

or

>= MySQL 5.0.3 use VARCHAR(2083)

check this answer

---

As you can see here, browsers can handle different URL lengths (and very long). So you should consider using text as data type.