On 27 Mar 2006 at 13:58, stab_bergbom wrote:

>I'm using Firebird 1.5 and have a table desclared as follows:
>CREATE TABLE OBJECTS (
> OBJECTNAME VARCHAR (30) CHARACTER SET ISO8859_1 NOT NULL COLLATE
>ISO8859_1,
>/* Primary keys definition */
>
>ALTER TABLE OBJECTS ADD PRIMARY KEY (OBJECTNAME);
>ID in table OBJECTS. What is wrong? Is the database corrupted and if
>so what could I do to fix this?

Never. I repeat: _never_ use non-default collation for character
field which is primary key.
And don't forget to use proper character set for connection.

--
SY, Dimitry Sibiryakov.