> I am having some weirdness with a database I am creating. I have
> created a program that read MySQL metadata and creates the
> equivalent table on a FB Server, and copies the data. Most of
> the tables work fine (there are +- 30 tbales). Two tables are
> giving me problems, both have many blob fields (14 at the most).
> What happens is the table is created with no error complaint (a
> primary key is supplied). But when I check the data the first
> two fields are filled with 0's (for an integer field) and blank
> (for a character field). I can change this data, but it reverts
> to the way it was previously on a commit. One table has 57
> various fields, the other only about 10. If I use the SQL my
> program generates to create the table, then create the table
> manually, it has the same effect, essentially a read only table.
> If I change the fields to Varchar(potentially truncating the
> data) it all works fine.
>
> Help. Please. Or I'll kick my cat. Hard.
>
> S

yes - saw this before... just sounds like your insert code is faulty. Its
not errant behaviour on the part of the server.. me thinks. I see your table
definition but what about the code you use to insert?
Alan