INSERT INTO .. SELECT with BLOB columns

[Peter Arrenbrecht]

Is it correct that "INSERT INTO new SELECT * FROM old" does not copy
BLOB columns? Or is there something I failed to configure properly?

Thank you,
Peter Arrenbrecht
Opus Software AG

[Serge Rielau]

You are mistaken. No column values are ever shared, including LOBs.
What's the symptom you see?

Cheers
Serge

[Peter Arrenbrecht]

Sorry, the values in the destination table are NULL. But I do suspect
that something in the application is wrong here. Please excuse the
trouble I caused.

Peter
Serge Rielau wrote:

You are mistaken. No column values are ever shared, including LOBs.
What's the symptom you see?

Cheers
Serge