We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Casting to LONG types without increase in size. — Vertica Forum

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?

Comments

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file