Yes, the website isn't just MySQL and the field has the type like varchar and not NULL values. So empty input will look like VALUES (NULL, ''); and in this case, you can't insert 2 similar records.

That’s exactly what I mean. If set to Unique and not mandatory, it must be Null.