Skip to main content

Casting to LONG types without increase in size.

  • November 15, 2014
  • 1 reply
  • 4 views
Said_Montiel
Forum|alt.badge.img+1
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?

    1 reply

    Nimmi_gupta
    Forum|alt.badge.img
    • Nimmi_gupta
    • Participating Frequently
    • November 19, 2014
    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.
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement