Submitted by: wesley blanco (wesleyblanco)

Duplicates CORE4213

script to reproduce:

CREATE TABLE TEST(
ID INTEGER,
UUID CHAR(16)
);
COMMIT;

/********* I want change only character set. *****************/
ALTER TABLE TEST ALTER UUID TYPE CHAR(16) CHARACTER SET OCTETS;
COMMIT;

/********** No erros, no update charset... **********/

SELECT A.RDB$FIELD_NAME,
A.RDB$RELATION_NAME,
B.RDB$CHARACTER_SET_ID,
C.RDB$CHARACTER_SET_NAME
FROM RDB$RELATION_FIELDS A
INNER JOIN RDB$FIELDS B ON B.RDB$FIELD_NAME = A.RDB$FIELD_SOURCE
INNER JOIN RDB$CHARACTER_SETS C ON C.RDB$CHARACTER_SET_ID = B.RDB$CHARACTER_SET_ID
WHERE RDB$RELATION_NAME = 'TEST';

RESULT:

RDB$FIELD_NAME RDB$RELATION_NAME RDB$CHARACTER_SET_ID RDB$CHARACTER_SET_NAME
=============================== =============================== ==================== ===============================
UUID TEST 0 NONE