I would add a "Transformation Line" scripting in the file's Metadata for replacing every NUL char with an empty string ''.
- In the File's properties, go into the Transformation tab
- Add this Script in the Line section:
- Set the Language to: rhino
=> make sure your mapping is using Load File to Rdbms (not the Postgres with Copy), so that Stambia's File Driver is used and applies the above script.
Note: the above solution works well but as always, undesired characters should be removed at the data source - if possible.