What is the correct column type for storing URLs in MySQL?

Question

I used varchar(300), but I also noticed longer URLs.

Answer 1

Use TEXTit is enough for everyone URL.

Note that with long URLs you cannot create an index that covers the whole URL. If you need an index UNIQUE, you must calculate the hash URL, store the hash separately, and index the hash instead.

Answer 2

Technically, HTTP does not limit the maximum length of a URL. Read this SO post.

varchar , TEXT

Answer 3

As you can see here , browsers can handle different URL lengths (and very long). Therefore, you should use it textas a data type.

Answer 4

For now:

<<MySQL 5.0.3 uses TEXT

or

> = MySQL 5.0.3 uses VARCHAR (2083)

check this answer