[teiid-issues] [JBoss JIRA] Updated: (TEIID-1021) Enable better support for mixed database encoding

Tue Mar 23 16:02:38 EDT 2010

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

Steven Hawkins updated TEIID-1021:
----------------------------------

    Fix Version/s: 7.1
          Affects: [Documentation (Ref Guide, User Guide, etc.), Release Notes]
       Complexity: Medium

Initially targeting at 7.1, but adding a small change to the Translator class to support bringing in blobs through the getBytes method.  Will also adding something similar to the postgresql convert_from function and possibly a binary type.

> Enable better support for mixed database encoding
> -------------------------------------------------
>
>                 Key: TEIID-1021
>                 URL: https://jira.jboss.org/jira/browse/TEIID-1021
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Server
>    Affects Versions: 7.0
>            Reporter: Mark Drilling
>            Assignee: Steven Hawkins
>             Fix For: 7.1
>
>
> 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. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira