Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4525

postgresql translator - remove all nulls & non printable characters

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Minor Minor
    • 10.2
    • None
    • JDBC Connector
    • None

      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

            rhn-engineering-shawkins Steven Hawkins
            omarbryankhan Omar Khan (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: