Subject RE: [firebird-support] FB3 alter domain colltion
Author Primoz Jenko
Post date 2018-05-17T09:52:27Z

Hi!

 

From FB manual, FB 2.5.x:

 

What ALTER DOMAIN Cannot Alter

  • If the domain was declared as an array, it is not possible to change its type or its dimensions; nor can any other type be changed to an ARRAY type.
  • In Firebird 2.5 and lower, the NOT NULL constraint can be neither enabled nor disabled for a domain.
  • 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.

 

 

Primoz

 

 

 

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, May 17, 2018 8:38 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] FB3 alter domain colltion

 

 

Hi,

 

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 :

Dynamic SQL Error

SQL error code = -104

Token unknown - line 1, column 38

COLLATE

 

is this possible or i should create ticket/or it already exists?

 

regards,

Karol Bieniaszewski

 


--
This message has been scanned for viruses and dangerous content by
E.F.A. Project, and is believed to be clean.
Click here to report this message as spam.


To elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite pošiljatelja, sporočilo pa takoj uničite.