We have an application which uses an object relation mapping tool to
access different databases. Since we need a case and accent
insensitive collation, we have developed a collation driver like the
new PT_BR in firebird 2.0. Because the mapping tool doesn't support
custom DDL statements, we have to find a method to set the default
collation for the entire database.
For now we changed the column RDB$DEFAULT_COLLATE_NAME in the system
table RDB$CHARACTER_SETS to our collation "WIN1252_NCNA" for the
built-in character set "WIN1252".
We discovered that this entry was reset to the system default
"WIN1252" after a backup and restore operation. The problem that
arises from this behaviour is that subsequent added fields have the
system defaultcollation.
Is there another way to set the default collation for the database?
If there isn't a solution for firebird 1.5.x maybe the new
firebird 2.0 could support a user specified default collation?
Is there a possibility to change the backup and restore operation so
that the changes to system tables are preserved?

Thank you very much in advance,

Stephan Perktold