in reply to dbd::oracle truncation error

Let me google that for you... there. Hope that helps.

perl -le'print map{pack c,($-++?1:13)+ord}split//,ESEL'

Replies are listed 'Best First'.
Re^2: dbd::oracle truncation error
by wal (Initiate) on May 30, 2016 at 14:30 UTC
    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
      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?