Hi All -

I’m trying to create a table with specific size for text fields.  In particular, I am storing a 3 byte character and an 8 byte character.  I tried the following but get errors:

CREATE TABLE te_LTRTest(chr int, pos int,  te_gag_protein tinyint, te_ap_protein tinyint, te_integrase_protein tinyint, te_rt_protein tinyint, te_rnaseh_protein  tinyint, te_chromodomain_protein tinyint, te_envelope_protein tinyint, te_ltr_age real, te_numb_ltrtes_inside integer, te_superfamily char'('3')', te_family char'('8')’);


Gives the error:


sql>\</workdir/lcj34/monetdbFiles/michelle_TE/create_teLTRTest.sql

syntax error, unexpected STRING, expecting ')' or ',' in: "create table te_ltrtest(chr int, pos int,  te_gag_protein tinyint, te_ap_protein"

sql>


Switching to this:

CREATE TABLE te_LTRTest(chr int, pos int,  te_gag_protein tinyint, te_ap_protein tinyint, te_integrase_protein tinyint, te_rt_protein tinyint, te_rnaseh_protein  tinyint, te_chromodomain_protein tinyint, te_envelope_protein tinyint, te_ltr_age real, te_numb_ltrtes_inside integer, te_superfamily char[3], te_family char[8]);


Gives the following error:

sql>\</workdir/lcj34/monetdbFiles/michelle_TE/create_teLTRTest.sql

syntax error, unexpected '[', expecting ')' or ',' in: "create table te_ltrtest(chr int, pos int,  te_gag_protein tinyint, te_ap_protein"

sql>


I have 2.1 billion rows so am using the binary bulk loads.  My non-numeric binary files were created to contain 3-byte values and 8-byte values.  This is what I am trying to load, however I’m not getting past the create table stage.  I love the binary loader.  This is the first time I’ve needed to include text data in my tables.  Is this supported?  I’m hoping it is just my syntax.

Any suggestions?

Thanks - Lynn