The use of control characters in postgres

Question

I am porting a legacy product over to Linux and its database over to postgres. Some of its data stored in varchars makes use a control character (ASCII 4) in the data.

Are there any constraints or issues I need to be aware of when storing any control characters in postgres varchars?.

Thanks.

Boris Schegolev · Accepted Answer · 2016-08-22 09:30:31Z

4

The only thing you can not really put into varchar is 0x00, as this is a string terminator. 0x04 works just fine, just like other non-printable characters.

answered Aug 22, 2016 at 9:30

Boris Schegolev

3,7115 gold badges23 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

The use of control characters in postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related