[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1021) Enable better support for mixed database encoding
[
https://jira.jboss.org/browse/TEIID-1021?page=com.atlassian.jira.plugin.s...
]
Steve Hawkins resolved TEIID-1021.
----------------------------------
Fix Version/s: 7.0
(was: 7.1)
Resolution: Done
Added the system functions encode/decode that can convert between blob and clob values.
The accepted encoding must be a string literal and is validated against the known java
encodings. A follow-up feature to this work would be to add encoding support for base64
and hex as well.
Enable better support for mixed database encoding
-------------------------------------------------
Key: TEIID-1021
URL: https://jira.jboss.org/browse/TEIID-1021
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.0
Reporter: Mark Drilling
Assignee: Steven Hawkins
Fix For: 7.0
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/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira