>>I guess the reason is that user may have existing indexes on fields using the
>>domain. Changing the collate would need to have the indexes rebuilt,
>>otherwise they would be "corrupted". So, to avoid that, FB >>doesn't allow
>>such changes.
Yes, that can be the reason but i think something
>>It is not clear why you included a COLLATE clause in an ALTER DOMAIN
>>statement. You can't change the COLLATE property of a domain, which
>>is why you got the error: COLLATE is not expected in an ALTER DOMAIN
>>statement. But you were not trying to change that, anyway.
>>HB
The question is why
Karol Bieniaszewski wrote:
> when we create dommain we can do:
> CREATE DOMAIN XXX TYPE VARCHAR(50) COLLATE PXW_PLK;
>
> but how to alter this domain to have still collation?
>
> ALTER DOMAIN XXX TYPE VARCHAR(150) COLLATE PXW_PLK;
>
>
> Engine Code: 335544569
> Engine Message :
>
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FB3 alter domain colltion
Hi,
>>There is no way to change the default collation without dropping the domain
>>and recreating it with the desired attributes.
>>Perhaps tool like IBExpert could do this – alter
Hi,
>>There is no way to change the default collation without dropping the domain
>>and recreating it with the desired attributes.
>>Perhaps tool like IBExpert could do this – alter and set collation? Not sure.
this was for FB2.5 where users could modify system tables but now in FB3 it is