SELECT my_unicode COLLATE DE_de FROM some_table
Хм. Я уже по всякому пробовал
SELECT _UTF8 'Z' COLLATE DE_de FROM RDB$DATABASE
UNION ALL
SELECT _UTF8 'A' COLLATE DE_de FROM RDB$DATABASE
UNION ALL
SELECT _UTF8 'a' COLLATE DE_de FROM RDB$DATABASE
ORDER BY 1
SELECT _UNICODE_FSS 'Z' COLLATE DE_de FROM RDB$DATABASE
UNION ALL
SELECT _UNICODE_FSS 'A' COLLATE DE_de FROM RDB$DATABASE
UNION ALL
SELECT _UNICODE_FSS 'a' COLLATE DE_de FROM RDB$DATABASE
ORDER BY 1
и всегда мне говорят COLLATION DE_DE for CHARACTER SET UTF8/UNICODE_FSS
is not defined.