What's new for no more varchar(255)
<p>I'm dealing with an old project, when I see there are tips "no more than 200 characters" (in Chinese), but the guy sets a column <code>varchar(255)</code>, it is obviously not right (it can only keep 255/3 length Chinese in UTF-8).</p>

<p>It is year 2016 (I mean old times gone, the <code>varchar(255)</code> definition rule should be broken), I saw MySQL supports setting varchar length to more than 255 characters. That is great!</p>

<p>But I'm not sure if other database engines like pgSQL or even MS SQL Server (though I never tried that), and what does the SQL standard say about it?</p>

<p>Can we break the <code>varchar(255)</code> rule?</p>