Change of character set in ALTER COLUMN does not work (FB2.5) -------------------------------------------------------------
Key: CORE-4213 URL: http://tracker.firebirdsql.org/browse/CORE-4213 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation, Engine Affects Versions: 2.5.1 Environment: Windows XP Reporter: Robert Priority: Minor 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 CORE-1058 but apparently only solved (and closed) for domains -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ How ServiceNow helps IT people transform IT departments: 1. Consolidate legacy IT systems to a single system of record for IT 2. Standardize and globalize service processes across IT 3. Implement zero-touch automation to replace manual, redundant tasks http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel