Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
GuptaN
Contributor
Contributor

CLOB Datatype migration

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

Labels (1)
1 Solution

Accepted Solutions
OritA
Support
Support

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.

View solution in original post

2 Replies
OritA
Support
Support

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
Specialist II
Specialist II

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