If I execute your table creation code (without the collate) on my
Firebird 2.1.1.17910 using ISQL I get an error:

"
Statement failed, SQLCODE = -607
unsuccessful metadata update
-STORE RDB$RELATION_FIELDS failed
-attempt to store duplicate value (visible to active transactions) in
unique index "RDB$INDEX_15"
"

So it looks like your case is not reproducible.

Mark

maverickthunder wrote:

> The point is that CREATE TABLE should fail always if the table have 2 rows with the same name.
>
> The table was like this:
>
> (some fields)
> "Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 4096,
> (some other fields)
> "Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 8192
> (end of definition)
>
> Both fields inside quotes. I tested again:
>
> CREATE TABLE "Demo" (
> "Codigo" INTEGER NOT NULL,
> "Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 8192,
> "Nombre" VARCHAR(50) NOT NULL COLLATE PXW_SPAN,
> "Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 4096
> );
>
> You will have only one field named Observaciones... then try this:
>
> ALTER TABLE "Demo"
> DROP "Observaciones";
>
> You will get an error.
>
> Using latest firebird 2.1.1.17910

--
Mark Rotteveel