Skip to content
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

Change of character set in ALTER COLUMN does not work (FB2.5) [CORE4213] #4538

Open
firebird-automations opened this issue Sep 10, 2013 · 1 comment

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Robert (rjm1102)

Is duplicated by CORE5825

Testing with FB 2.5 (WI-V2.5.1.26351), also detected on FB 3.0 alpha

Test set:

/* create varchar column with character set ISO8859_1 */
ALTER TABLE MyTable
ADD MyColumn VARCHAR(50) CHARACTER SET ISO8859_1

/* change character set to ISO8859_2 */
ALTER TABLE MyTable
ALTER COLUMN MyColumn TYPE VARCHAR(50) CHARACTER SET ISO8859_2

Test result: no syntax error but character set is still ISO8859_1
Expected: ISO8859_2 (or syntax error that character set clause is not allowed)

Note: changing character set for domains works correctly.

Note: same error was reported under CORE1058 but apparently only solved (and closed)
for domains

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE5825 [ CORE5825 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant