[teiid-issues] [JBoss JIRA] (TEIID-4525) postgresql translator - remove all nulls & non printable characters

postgresql translator - remove all nulls & non printable characters ------------------------------------------------------------------- Key: TEIID-4525 URL: https://issues.jboss.org/browse/TEIID-4525 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Reporter: Omar Khan Assignee: Ramesh Reddy Priority: Minor Fix For: Open To Community, 10.0 Would like to see the postgresql translator enhanced to add a feature to minimum remove nulls from text strings as some other databases i.e. Teradata allow for them where Postgres does not. This feature would behave in a similar manner as TrimSpaces, but simply remove all \u0000 characters. Furthermore, if possible, would like the ability to remove non printable characters to as another option provide another additional stripping mechanism, allowing the postgresql database to serve as a data cleaner if need be. Please refer to https://developer.jboss.org/thread/272644 for details