If we're converting from char[n] to String, I thought that was the solution to NOT truncate.

So why a rule to say it will be truncated.

Can there also be a rule put in place in designer such that if char data type is used, that length cannot be changed from 1?

char[n+] field is truncated by importer --------------------------------------- Key: TEIIDDES-2061 URL: https://issues.jboss.org/browse/TEIIDDES-2061 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 8.3.1 Reporter: Johnathon Lee Assignee: Barry LaFond Fix For: 8.4, 8.3.2 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].