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

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy reassigned TEIID-4525:
-----------------------------------

    Assignee:     (was: Ramesh Reddy)


> 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



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)