Re: How to handle larger databases?

On Mon, Nov 22, 2004 at 11:33:35AM +0000, Matt wrote:
> > Especially since PostgreSQL has no fixed length string types, so
> > following that advice would exclude any strings. That's kind of
> > useless.
>
> char(n) ?

Is not fixed length. The actual size varies by encoding. Consider the
string:

zeeën

Latin-9 5 bytes
UTF-8 6 bytes
UTF-16 10 bytes

But it should still fit in a char(5), wouldn't you agree?

In postgresql there is no difference in storage method between text,
varchar(n) and char(n).
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.