Re: Which character data type to use?

martin.chantler@convergys.com writes:

> For storing character data such as surname, email address which
> is the best data type to use?

See FAQ item 4.15.  VARCHAR is my suggestion.

> Can each of these be indexed???

Yes

> Which of these is fastest considering hard disks are so cheap I don't much care
> about which takes the most bytes!

You're dead wrong if you're thinking that way.  The issue is not that hard
disk space is cheap, it's that cache memory is scarce.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/