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.

Ответить