By using AWS re:Post, you agree to the Terms of Use
/DMS not replicating chr(0) from source to target/

DMS not replicating chr(0) from source to target

0

Hi, Chr(0) is present in the source data and dms is not migrating this character to target. DMS transfers all non-printable characters except chr(0). Due to this DMS reports these records as mismatched records. Is there any workaround for this in DMS to retain chr(0) in target. Source DB:rds oracle Target :AUrora postgresql 13.X

Sample insert query: insert into non_ascii_test values (1,'This string doesnt contain non-printable ascii characters'); insert into non_ascii_test values (2,'This string contains non-printable ascii characters'||chr(1)||chr(2)||chr(3)||chr(4)||chr(5)||chr(6)||chr(7)||chr(8)||chr(9)); insert into non_ascii_test values (3,'This string contains non-printable ascii characters'||chr(1)||chr(2)||chr(3)||chr(4)||chr(5)||chr(6)||chr(7)||chr(8)||chr(9)); insert into non_ascii_test values (6,chr(0)||chr(1)||chr(2)||chr(3)||chr(4)||chr(5)||chr(6)||chr(7)||chr(8)||chr(9)||chr(10)||chr(11)||chr(12)||chr(13)||chr(14)||chr(15)||chr(16)||chr(17)||chr(18)||chr(19)||chr(20)||chr(21)||chr(22)||chr(23)||chr(24)||chr(25)||chr(26)||chr(27)||chr(28)||chr(29)||chr(30)||chr(31)||'test non-ascii print'||chr(0)||chr(1)||chr(2)||chr(3)||chr(4)||chr(5)||chr(6)||chr(7)||chr(8)||chr(9));

Thanks Bharath

1 Answers
0

chr(0) is null , which is not supported in Postgres. Reference: https://www.postgresql.org/message-id/47CC2576.9090609%40netwolves.com

Try replacing chr(0) with some other character. such as chr(1).

answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions