I am working with a software developer who has a vertical market cargo program. We will be importing customer & vendor profiles as well as transactions into Adagio. During this exercise the question came up as to the difference between Adagio’s CHAR and RCHAR data types as specified in the Data Dictionary.
I am very familiar with the difference between CHAR and VARCHAR data types in SQL. In the Adagio environment are CHAR data fields fixed length, right padded and VARCHAR variable length with trailing spaces?