Subject | Bug ? |
---|---|
Author | Vander Clock Stephane |
Post date | 2012-01-05T09:52:46Z |
i don't know if this a bug, just to confirm
CREATE DATABASE 'c:\test_utf8.fdb'
USER 'sysdba'
PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET UTF8;
CREATE TABLE TEST_A(
ID VARCHAR(32) NOT NULL,
DATA1 VARCHAR(5000),
DATA2 VARCHAR(5000),
DATA3 VARCHAR(5000),
DATA4 VARCHAR(5000),
DATA6 VARCHAR(5000),
DATA10 VARCHAR(5000),
PRIMARY KEY (ID)
);
=> ERROR new record size is too big (that ok)
but now
CREATE TABLE TEST_A(
ID VARCHAR(32) NOT NULL,
PRIMARY KEY (ID)
);
=> ERROR cannot create index RDB$PRIMARY2 !!!
stéphane
CREATE DATABASE 'c:\test_utf8.fdb'
USER 'sysdba'
PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET UTF8;
CREATE TABLE TEST_A(
ID VARCHAR(32) NOT NULL,
DATA1 VARCHAR(5000),
DATA2 VARCHAR(5000),
DATA3 VARCHAR(5000),
DATA4 VARCHAR(5000),
DATA6 VARCHAR(5000),
DATA10 VARCHAR(5000),
PRIMARY KEY (ID)
);
=> ERROR new record size is too big (that ok)
but now
CREATE TABLE TEST_A(
ID VARCHAR(32) NOT NULL,
PRIMARY KEY (ID)
);
=> ERROR cannot create index RDB$PRIMARY2 !!!
stéphane