CLOB Datatype migration

[GuptaN]

trying to migrate clob column from source to target without any transformation but getting \n extra.

for example:- source string:-"I  got   A+   in class"

 in target getting:- "I\n got\n A+\n in class"

Please guide on this.

Thanks and Regards,

GuptaN

[OritA · Accepted solution]

This seems to be a hex value that is translated based on the characterset that is defined in the source db endpoint and in the target db endpoint. You can control the translation using the option 'Character Substitution' under task setting. For exact instruction you can either refer to documenation or open a case for support. Please include in the case details the characterset of the source db and the target db.

[Heinvandenheuvel]

In your example I  see no  "\n" for the whitespace in "in class". Is that a typo in the example or is the "\n" there for some whitespace but not other? 

Could the "\n" be present on source but not visible with the source tools? Please try to provide a partial HEX dump for a sample source string. For an Oracle source that could be DUMP (column, 1010, 1, 100). For SQL server that could be SELECT CAST (column as VARBINARY(100))

Please also show the target endpoint internal settings (from JSON export or UI) to see if 'replaceChars' is active.

Hein