Probably depends on the DB. For example, the Postgres manual states that there are no performance or space differences between varchar(n) and text except for "a few extra CPU cycles to check the length when storing into a length-constrained column".