Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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?


  • 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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.