Hello,

How to set collate on computed by field?

CREATE TABLE ZMONES (
ZMOGAUSID TID NOT NULL,
VARDAS TTRUMPASTEKSTAS,
PAVARDE TTRUMPASTEKSTAS NOT NULL,
VARDASPAVARDE COMPUTED BY (coalesce(vardas, '') || ' ' ||
coalesce(pavarde, '')) COLLATE LT_LT
);
**********************************************************************
The next statement causes the following error:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 5, column 93.
COLLATE.
**********************************************************************


Thank You!