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

postgresql translator - remove all nulls & non printable characters

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: