New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
"alter domain" supporting collation change [CORE1202] #1627
Comments
Modified by: @pcisarVersion: 2.1 Initial [ 10160 ] Version: 2.1 Beta 1 [ 10141 ] => Version: 2.1.0 [ 10041 ] => |
Modified by: @pcisarWorkflow: jira [ 11751 ] => Firebird [ 14319 ] |
Commented by: @sim1984 As recently direct editing system tables is prohibited, the need for this sql statement became more evident. In particular IBExpert previously allowed to change the collation modifying system tables. Now that opportunity taken away. |
Commented by: Radek Palmowski (palma) This is a very serious restriction that inhibits migration to FB3. It is possible to change priority of this issue? |
Commented by: @livius2 It is not only limitation it work now wrongly as it alter collation to some default. CREATE DOMAIN XXX Varchar(1000) CHARACTER SET WIN1250 COLLATE PXW_PLK; now when you alter its e.g. size ALTER DOMAIN XXX TYPE VARCHAR(2000); it will be after alter equivalent to CREATE DOMAIN XXX Varchar(2000) CHARACTER SET WIN1250 COLLATE WIN1250; as you can see it change PXW_PLK to WIN1250; |
Submitted by: Jorge Andres Brugger (jbrugger)
Relate to CORE6324
Votes: 12
Related to CORE1058: "ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation"
CREATE DOMAIN D_TEST AS
VARCHAR(10) CHARACTER SET ISO8859_1
COLLATE ES_ES
You can do:
alter DOMAIN d_test type
VARCHAR(10) CHARACTER SET iso8859_1
But you can't do:
alter DOMAIN d_test type
VARCHAR(10) CHARACTER SET iso8859_1
COLLATE ES_ES
Adding collate support for alter domain would be useful
The text was updated successfully, but these errors were encountered: