Thread: Varchar and indexing..

Varchar and indexing..

From

Mitch Vincent

Date:

12 February 2001, 18:33:14

Hi guys.. Is there a limit on the maximum indexable size to varying
character fields?

Just so I'm clear, you can index varying character fields (and use the
indexes) -- right?

Thanks!

-Mitch

Re: Varchar and indexing..

From

Peter Eisentraut

Date:

12 February 2001, 19:16:13

Mitch Vincent writes:

> Hi guys.. Is there a limit on the maximum indexable size to varying
> character fields?

About 2700 bytes, IIRC.

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