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

Nov 12 '05 #1

Serge Rielau

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

Cheers
Serge

Nov 12 '05 #2

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

Nov 12 '05 #3