| Subject | Re: Index on character type column: CHAR or VARCHAR ? |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2004-09-17T11:25:09Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" wrote:
252 bytes (give or take a few, Ann amongst others know the exact
number) can be indexed, but assign a character set and each character
starts taking two or three bytes and you are may end up with not being
able to index a field of type (VAR)CHAR(85).
Set
> Someone will correct me if I'm wrong but indexes are limited to 128OK, since you ask so kindly - I will correct you: Fields up to around
> bytes,
252 bytes (give or take a few, Ann amongst others know the exact
number) can be indexed, but assign a character set and each character
starts taking two or three bytes and you are may end up with not being
able to index a field of type (VAR)CHAR(85).
Set