At 02:13 PM 24-07-02 +0000, roman rokytskyy wrote:

>Hi,
>
>a) in general, this is a question to IB-Support group;
>b) in InterBase/Firebird size of an index entry is limited to 127
>bytes. when you declare field unique, server creates an index
>automatically. so, you either remove 'unique' constraint on
>the 'name' column, or reduce size of the column to 127.

Actually, the index size limit is around 248 characters for a single-byte
character set, around 125 for two-byte and around 81 for three-byte. The
sizes are approximate because the size of "info bytes" stored on an index
varies slightly.

Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________