| Subject | specify size of the index on the text field |
|---|---|
| Author | Michal Žeravík |
| Post date | 2004-11-22T07:48:04Z |
Hi,
I have newbie question:
is it possible to declare explicitly size of the index on [var]char column?
When I have ie. varchar(255), can I specify index for sorting only from
i.e. first 5 letters?
Something like create index xx on tablee(myvarchar(5));
thank you
Michal
I have newbie question:
is it possible to declare explicitly size of the index on [var]char column?
When I have ie. varchar(255), can I specify index for sorting only from
i.e. first 5 letters?
Something like create index xx on tablee(myvarchar(5));
thank you
Michal