Re: varchar2(size)

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Wed, 30 Sep 2009 12:48:53 -0700 (PDT)
Message-ID: <410d0981-a403-4dfd-bf80-e7f38a4c7836_at_k41g2000vbt.googlegroups.com>

On Sep 30, 3:19 pm, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:

snip

> What if you need to save Mr. Seamus Wolfeschlegelsteinhausenbergerdorff's name in
> your database?  What if his daughter then gets married and hyphenates her name with
> her husband's?
>
> Many "maximum" sizes are really just arbitrary guesses.

Ahh then simply make everything varchar2(2000) that should fix it all rightey eh? No worries then make all your varchar2 fields like this then ...

If you are just guessing then please stay away from my databases. Rules can change over time and database systems can handle some reasonable number of implementation changes when required. Received on Wed Sep 30 2009 - 14:48:53 CDT