| Subject | Re: [firebird-support] FB3 alter domain colltion |
|---|---|
| Author | Carlos H. Cantu |
| Post date | 2018-05-18T14:15:17Z |
| The question is why i can not do this? I need to change collation to perform order and UPPER without need to include COLLATE in it |
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.
Carlos
www.firebirdnews.org - www.FireBase.com.br