Thomas Steinmaurer wrote:

>>>Please remind me, what is the max key size in FIrebird 1.5?
>>>
>>>I just failed to create a compound index on these two columns:
>>>- int
>>>- varchar(200)
>>
>>Then you are using a multi-byte character set and/or
>>multi-byte collation.
>
> Well, not entirely true. ;-)
>
> Ivan's calculator says, that with your above scenario you are exceeding the
> limit, even with a single-byte character set and/or collation.

Apparently. :-( But I think I did specify a collaction. And I think it's
ok to reduce the column size to 190 characters for example.

> <firebird_20_plug>
> In Firebird 2.0, the limit has been increased and depends on the database
> page size.
> </firebird_20_plug>

That's good to know, but this is a production environment so I'll stick
with 1.5.3 until 2.0 is officially released.

Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64