--- In firebird-support@yahoogroups.com, "Alex Antunes"
<alex.antunes@...> wrote:

>
> Hi,
>
> I have try uptdate a domain only one simple change.
>
> Original Domain:
>
> Atributo_Tipo Varchar (3) Charset Win1252 Collate Win1252
>
> I was try to change:
>
> Atributo_Tipo Varchar (3) Charset Win1252 Collate PWX_INTL850
>
> BD was in use.
>
> All users do not response applicantions.
> The IB Expert do not responding
>
> The Application running on ASP web Server.
>
> The operator Host need to restart FB Service and app running OK!
>
> Question:
>
> The Database Structure domain only be update in exclusive access ?
>
> Alex Antunes
>

Hi Alex,

as far as I know if you use ALTER DOMAIN you can not change the collate.

An ALTER DOMAIN sentence can be used for:

- renaming the domain
- modify the data type
- drop or set a default value
- drop or add a check constraint

Plus you probably have to deal with changes affecting values already
present.

Regards,

Guillem