On Mon, Aug 28, 2006 at 15:04:26 -0400,
Richmond Dyes <rdyes(at)monroehosp(dot)org> wrote:
> I know the difference between char and varchar is char is fixed length
> and varchar returns variable length. Which one should be used and why?
You normally want to use 'text' instead of either 'char' or 'varchar'.
Unless there is a business rule limiting the length of a string (and sometimes
not even then) you want to use 'text' as it is more flexible.