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

Enable better support for mixed database encoding

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.0
    • Fix Version/s: 7.0
    • Component/s: Server
    • Labels:
      None
    • Affects:
      Documentation (Ref Guide, User Guide, etc.), Release Notes
    • Estimated Difficulty:
      Medium

      Description

      I was working with a Japanese PostGreSQL database - database encoding is SQL_ASCII, but some of the columns have EUC_JP encoded data. I attempted to create a UDF to utilize the PostGreSQL convert(string, sourceEncoding, targetEncoding) function, but had difficulty with that (in the production version 554). Eventually we were able to workaround with other code changes, but handling of this situation may have been easier with a byte data type - logging this JIRA for consideration in teiid.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                mdrillin Mark Drilling
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: