Casting to LONG types without increase in size.

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?


  • Options
    Nimmi_guptaNimmi_gupta - Select Field - Employee
    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file