Re: Picking CHAR over VARCHAR2

From: keith boulton <boulke_at_globalnet.co.uk>
Date: Sat, 06 Mar 1999 13:40:36 GMT
Message-ID: <36e12ec6.3110953@read.news.global.net.uk>

On Wed, 24 Feb 1999 11:16:49 -0500, "Rodgers, Tony (CEI-Atlanta)" <Tony.Rodgers_at_cox.com> wrote:

>Sometimes it makes sense to put certain kinds of data in a char column.
>For example, a state abbreviation which is always two characters.

Unless you want the (peculiar) comparison behaviour, there is no reason to use char over varchar2, they are stored internally in exactly the same format. Received on Sat Mar 06 1999 - 07:40:36 CST