The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Space characters in Vertica table

Hello,
I am experiencing a unique box type representation in the vertica table, this is appearing due to the value : "\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000"

looks like

Please help us identify how to escape these characters or to convert this to spaces.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
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.