VARCHAR ( n )
From: Stefan Ram <ram_at_zedat.fu-berlin.de>
Date: 22 Nov 2016 12:38:55 GMT
Message-ID: <VARCHAR-20161122133452_at_ram.dialup.fu-berlin.de>
[Quoted] When a field usually has about 8 characters, but there is no absolute upper limit (think of the first name of a person), is there any drawback in specifying a VARCHAR argument that is much larger, say, for example, »VARCHAR ( 9999 )«?
Date: 22 Nov 2016 12:38:55 GMT
Message-ID: <VARCHAR-20161122133452_at_ram.dialup.fu-berlin.de>
[Quoted] When a field usually has about 8 characters, but there is no absolute upper limit (think of the first name of a person), is there any drawback in specifying a VARCHAR argument that is much larger, say, for example, »VARCHAR ( 9999 )«?
[Quoted] We can safely assume that no first name will have more than 100 characters, but is there any drawback to use an upper limit that is much larger? (in MySQL 5.7) Received on Tue Nov 22 2016 - 13:38:55 CET