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<http://www.efa-project.org>, and is believed to be clean. Click here to report this message as spam.<http://mailr.domplan.si/cgi-bin/learn-msg.cgi?id=3C3A32004D.AB07B&token=5f2032328647ecf18cf7cca483f077e6> ________________________________ 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.
