Why does MySQL ignore the data type length of a column?

Question

I'm using MySQL8.0 and I'm trying to store URLs in columns. Every time I try to insert a URL that is longer than 191 characters, I get the following error: 1406Datatoolongforcolumn'url'atrow1 The column data type is VARCHAR(1000) and the URL is about 450 characters. I've tried inserting other strings and anything under 191 characters, and anything below 191 characters works fine, but nothing above 191 characters. I tried to make this column's data class

P粉002546490 · Answer

Taken from here:

On a database that uses a utf8mb collation, each character takes 4 bytes.
On innodb, indexes (the prefixes to be exact) can contain up to 767 bytes.

So, the max indexable length on utf8mb + innodb is 767/4=191 characters.

So you'd better use TEXT format for your URL.

renew:

According to this answer, the problem is with the character set, when it needs to be utf8, it is utf8mb4, same collation.