]
Steven Hawkins updated TEIID-4525:
----------------------------------
Fix Version/s: Open To Community
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
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