in reply to Re: dbd::oracle truncation error
in thread dbd::oracle truncation error

I googled a lot I'm using a tool ora2pg which takes the data in oracle and move it to postgres in oracle this is a varchar(80 byte) field PG ref_property character varying(80), ref_house character varying(80), ref_object character varying(80) so I don't know why it throws this exception

Replies are listed 'Best First'.
Re^3: dbd::oracle truncation error
by wal (Initiate) on May 30, 2016 at 15:44 UTC
    maybe I found something strange the select lenght(ref_object) = 80 and the lengthb(ref_object) = 80 the field is varchar2(80 bytes) strange is that the length and lengthb gives the same length but ref_object has some special characters? so how can the length be equal?