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 <[EMAIL PROTECTED]> 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.
pgpQHknaAF0CO.pgp
Description: PGP signature
