Casting to LONG types without increase in size.

Said_Montiel

I want to be able to cast from one data type to LONG VARCHAR, but it seems to be adding leading/trailing spaces (to fit the LONG VARCHAR set limit) as part of the casting operation.

I would like to avoid this behavior as it doesn't fit my table needs.

Similarly, would this happen in a LONG VARBINARY conversion?

Nimmi_gupta

Would it be possible to share a sample example you are trying. And also send the result of the example. We would like to review.