Use oracle DUMP function to see internal representation of a character field, e.g. to see hidden trailing characters as in example below: ENTERPRISE_ID EMPLOYER_ID SOURCE_BUSINESS_ID SOURCE_FRIENDLY_ID GOVERMENT_AGENCY_FG SETUP_COMPLETED_FG ————- ———– ————————————————– ——————– ——————- —————— 27905692 13034613 3C02DB52-52C1-43B1-98DE-EA75CA9AB7AC BULS_6930 N Y …

Oracle DUMP function Read more »