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개 답변
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).

AWS
답변함 2년 전
profile picture
전문가
검토됨 한 달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠