[GENERAL] Varchar Indexing

[mitch]

Is there a size limit on indexable varying character fields?

I need a semi-large varchar field (say 2048 characters) but really need
the speed of an index in searching, I'm left wondering at what point
indexing varchar fields becomes useless (if it ever does)..

Thanks!

-Mitch