as know have 2 types of varchar2 in oracle
e.g. col1 varchar2(20 byte) col2 varchar2(20 char) when migrate data different database (e.g. netezza) should correct length.
col1 should 20 col2 should 20 or 20x4= 80 ? because 1 char = 4 bytes
thanks
to idea how bytes data takes up.
select max(lengthb(column)) table this give max length in bytes of values in column specified. it's highly unlikely characters take 4 bytes.
Comments
Post a Comment