1 Reply Latest reply: Jan 13, 2014 1:47 PM by Himanshu Rai RSS

    Varchar data type in ODI (in chars or bytes) ?

    mmtn_jy


      Hi,

      In Oracle db when we create a varchar2 data type column we specify the length in chars or bytes, For e.g. col1 varchar2(16 char) or col2 varchar2(16 bytes). But when we reverse this in odi, the model only shows the logical length of 16. Does ODI store whether 16 is number of bytes or char ?

      Say If I were to change the data type of column from col1 varchar2(16 bytes) to varchar2(16 char) in oracle table, do I need to change it in ODI ? If so how ? I could not find where logical length of column is mentioned as char or byte.

       

      Thanks.