Hello Pavel,

>I prefer to use
> domains and define collations in them - then you can recreate the
> database with another character set and collations via script, for
> example).

It's a good idea!

> As I understand, it is not recommended to use selectable stored
> procedures in the way you do: it is recommended to restrict the
> procedure output and order the data inside the procedure, otherwise FB
> has to retrieve all rows from the SP, and then filter and order them.

My stored procedures are already restricted via input parameters,
but the users need to restrict them with more filters.

> And inside the SP you could use UPPER, etc. without problems if you
> defined collations for tables fields.

Yes, it is.

> d> Maybe there is the way to setup one collation order for all

objects in

> d> database?
> Probably changing the system tables directly, but it may be unsafe.

I prefer not to change system tables.

I'll modify my application to use UPPER with collate filtering as the
most useful solution.

Many thanks for the help.


Best regards,
Vadim Kharsko
AVEST plc.
http://www.avest.by