At 02:30 PM 31/10/2003 +0000, you wrote:

>OK I am doing something wrong here ( I think )
>
>I've taken a PHP website package database written for MySQL
>and converted it to FB1.5. Usual problems with BLOB, TEXT
>and LONGTEXT, but I don't worry about those. The sticking
>point is the use of UNIQUE. There are several VARCHAR(255)
>strings with a UNIQUE key set. I SHOULD be able to do that
>with a simple ascii string - shouldn't I? It complains that
>the key is too long - so what am I missing, I thought that
>255 characters was OK. If not, how do I get round this?

Reduce them to 253 (varchar) or 254 (char). You've blown the limit on no.
of bytes for an index. :-)

h