Привет алл.
Вот решил начинать по маленьку преходить на FB (2.1).
База на UTF8.
Делаю вот такую немаленькую табличку:
CREATE TABLE MD_ECHO_CG_PROTOCOL (
ID BIGINT NOT NULL,
MAN_ID BIGINT,
STA1_ID BIGINT,
STA1_SPEC_ID VARCHAR(6),
STA2_ID BIGINT,
STA2_SPEC_ID VARCHAR(6),
SUBTYPE VARCHAR(16),
ECHO_QUALITY SMALLINT,
ECHO_QUALITY_PAR SMALLINT,
ECHO_QUALITY_API SMALLINT,
RHYTHM_XMIN SMALLINT,
RHYTHM SMALLINT,
SUBMAX_PULSE SMALLINT,
AO DOUBLE PRECISION,
LA DOUBLE PRECISION,
KA DOUBLE PRECISION,
LK DOUBLE PRECISION,
LK_METHOD SMALLINT,
CHAMBER_PARTITION DOUBLE PRECISION,
TRUNCUS_PULMONALIS DOUBLE PRECISION,
BACK_WALL DOUBLE PRECISION,
KK_MASS_INDEX DOUBLE PRECISION,
EDD DOUBLE PRECISION,
EDV DOUBLE PRECISION,
ESD DOUBLE PRECISION,
ESV DOUBLE PRECISION,
EF DOUBLE PRECISION,
EF_METHOD SMALLINT,
FS DOUBLE PRECISION,
DIAST_FUNCT SMALLINT,
DIAST_FUNCT_DESC VARCHAR(512),
IVRT SMALLINT,
EA SMALLINT,
DT SMALLINT,
AV VARCHAR(512),
AV_FG DOUBLE PRECISION,
AV_CM DOUBLE PRECISION,
AV_1 SMALLINT,
MV VARCHAR(512),
MV_FG DOUBLE PRECISION,
MV_CM DOUBLE PRECISION,
MV_1 SMALLINT,
TV VARCHAR(512),
TV_FG DOUBLE PRECISION,
TV_CM DOUBLE PRECISION,
TV_1 SMALLINT,
PV VARCHAR(512),
PV_FG DOUBLE PRECISION,
PV_CM DOUBLE PRECISION,
PV_1 SMALLINT,
PERICARDIUM SMALLINT,
PERICARDIUM_DESC VARCHAR(512),
PATIENT_USED_DRUGS VARCHAR(2048),
COMPLAINT VARCHAR(2048),
WMA1 CHAR(17) CHARACTER SET NONE DEFAULT
'00000000000000000',
WMA2 CHAR(17) CHARACTER SET NONE DEFAULT
'00000000000000000',
WMA3 CHAR(17) CHARACTER SET NONE DEFAULT
'00000000000000000',
DOPPLER_ECHO_LAYOUT BLOB SUB_TYPE 0 SEGMENT SIZE 4096,
DIAGNOSIS VARCHAR(2048),
UNUSED_REPORT_NUMBER INTEGER,
LUNG_VENA SMALLINT,
DRAINAGE VARCHAR(2048),
LEFT_ATR_LUG SMALLINT,
RIGHT_ATR_LUG SMALLINT,
FORAMEN_OVALE_APERTUM SMALLINT,
PULSE_REST_STATE SMALLINT,
PS_MAX SMALLINT,
TA_REST_STATE SMALLINT,
TA_MAX SMALLINT,
DRUGS_DOBUTAMIN DOUBLE PRECISION,
DRUGS_ATROPINE DOUBLE PRECISION,
DRUGS_BELOC DOUBLE PRECISION,
TEST_INTERRUPTION_REASON VARCHAR(4096),
ECG_BEFORE_TEST VARCHAR(4096),
ECG_DURING_TEST VARCHAR(4096),
ECHO_BEFORE_TEST VARCHAR(4096),
ECHO_DURING_LOAD VARCHAR(4096),
CONCLUSION BLOB SUB_TYPE 0 SEGMENT SIZE 4096,
ATR_BULKHEAD_CHK1 SMALLINT,
ATR_BULKHEAD_CHK2 SMALLINT,
ATR_BULKHEAD_DESC1 VARCHAR(512),
ATR_BULKHEAD_DESC2 VARCHAR(512)
);
И полчаю:
This operation is not defined for system tables.
unsuccessful metadata update.
new record size of 139840 bytes is too big.
TABLE MD_ECHO_CG_PROTOCOL.
На Yaffil-е тако проходило. Там только база полностю была под WIN1257.
Что ето такое ?
Какоито лимит по сумме VARCHAR-ов чтоли на однои таблице ?
Regards
Janex
