Hi Thomas,

> As this is a pure Firebird database issue in respect to collations and
> indexes, I guess this is independent of the access technology you use?
> Or does Python/SQLAlchemy generates your mentioned SQL statement behind
> the scene?
>

The SQL is generated in the Python code and the database schema/create
is done based on the SQLAlchemy model (metadata.create_all(fbengine) .

I found how to do the "create index" from Python/SQLalchemy in a way
that it is done only on creation of the db and with whatever collation I
specify.

Werner