Varchar and indexing..

Started by Mitch Vincentabout 25 years ago2 messagesgeneral
Jump to latest
#1Mitch Vincent
mvincent@venux.net

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

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Mitch Vincent (#1)
Re: Varchar and indexing..

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/