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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-4525.
-----------------------------------
    Resolution: Done


Added the RemovePushdownCharacters execution property to the JDBC translator which is general enough to remove both null and 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
>            Priority: Minor
>             Fix For: 10.x
>
>
> 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



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)