3 Replies Latest reply on Oct 14, 2016 9:24 AM by Steven Hawkins

    postgresql translator - remove all nulls & non printable characters from text?

    Omar Khan Novice

      Hi - I'm having to wrap my text fields in teiid with  REPLACE(field, '\u0000', '') to remove nulls as postgreql or I will get :

       

      Postgres error on insert - ERROR: invalid byte sequence for encoding “UTF8”: 0x00

       

      I was wondering, perhaps if something could be added to the translator strip all non-printable characters ? I at this point can only remove nulls. I did also try the following pattern - but it didn't work: \p{C}

      or maybe there is another way to do it more efficiently than just wrapping various text field with a bunch of replace(s)?