A computed column is calculated at run time, the values aren't stored
anywhere, so how would you store a collation? I'm by no means
experienced with collations, but would suggest that you specify the
collation in your select:

SELECT VARDASPAVARDE COLLATE LT_LT
FROM ZMONES

I don't know whether it is necessary to specify the collation or not if
TTRUMPASTEKSTAS is defined with the collation.

HTH,
Set

jasajona wrote:

> 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!