Re: VARCHAR ( n )

[Quoted] [Quoted] Axel Schwenke <axel.schwenke_at_gmx.de> writes:
> it is good practice to always use
>the smallest possible data type

[Quoted] [Quoted]   The problem is that there often is no precise [Quoted]   upper limit for the length of some kind of data (texts).

[Quoted] [Quoted]   For example, a first name usually is no longer   than 32 characters, but when one uses VARCHAR ( 32 ),   it might happen that eventually someone with   33 characters in his first name comes along. So,   one might use VARCHAR ( 33 ), but then someone   with 34 characters might appear.

  (This might be related to the

en.wikipedia.org/wiki/Sorites_paradox

[Quoted]   .) See also,

Keihanaikukauakahihuliheekahaunaele Received on Tue Nov 22 2016 - 14:27:04 CET