You are correct about the error:
Code: Select all
dbadmin=> create table test (col1 varchar(1));
CREATE TABLE
dbadmin=> insert into test values ('AA');
ERROR 4800: String of 2 octets is too long for type Varchar(1)
Code: Select all
select is_flextable from tables where table_schema = 'staging' and table_name = 'subject_demographics';
Look at the keys to get the data type and size...
Code: Select all
select compute_flextable_keys('staging.subject_demographics');