[ https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2061 at 2/19/14 4:06 PM: ----------------------------------------------------------------- So it looks like the issue here is Designer needs to recognize a *char* datatype as a single character with length of 1. 1) Look at data-type managers and insure that mapping during import converts all *char* with *length > 1* to a type *string* 2) Create validation rule to flag any *char* values with *length > 1* * Warning Message something like: ** *The Teiid runtime datatype for char only recognizes a length of 1. Any additional characters will be truncated.Suggest changing datatype to string.* was (Author: blafond): So it looks like the issue here is Designer needs to recognize a *char* datatype as a single character with length of 1. 1) Look at data-type managers and insure that mapping during import converts all *char* with *length > 1* to a type *string* 2) Create validation rule to flag any *char* values with *length > 1* * Warning Message something like: ** *the Teiid runtime datatype for char only recognizes a length one. Additional characters will be truncated.Suggest changing datatype to string.* -- 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