[
https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu...
]
Steven Hawkins commented on TEIIDDES-2061:
------------------------------------------
Maybe the following will help:
The Teiid char type maps to a Java Character (most of the original runtime types were,
like Hibernate, just representations of the Java type).
Only a char[1] database type should map to the Teiid char type.
Otherwise a char[n] database type should map to s Teiid string type.
Although, the lack of distinguishing between fixed and variable length strings does cause
some issues for Teiid (memory management is harder, databases tend to return padded
values, comparisons may require extra settings, etc.).
char[n+] field is truncated by importer
---------------------------------------
Key: TEIIDDES-2061
URL:
https://issues.jboss.org/browse/TEIIDDES-2061
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Affects Versions: 8.3.1
Reporter: Johnathon Lee
Attachments: testErrors.vdb
truncation of Char[>1] fields to one character.
reproduction with simple VDB (to be attached):
SELECT asChar,asVarChar,asInt FROM "TestErrors"."TruncateCHAR";
the "asChar" field only returns a "C" and the asVarChar returns
the complete value.
That is the expected behavior, per the Data Virtualization Reference Manual, char
datatype is a single Unicode character (java.lang.Character). However, the importer may
need to check for the occurrence of char[n+] and not assume char[1].
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira