storing apostrophe(')

[sateeshbabu]

Hi,

The source data is like this M'Sateesh and the column is of varchar2(9) in both source and target but when i am trying to load the data it says "value too large for column actual: 10, maximum: 9 eventhough it is coming 9 from input.

When i tried to insert this value in database using statement by embed single quote M''Sateesh , it was inserted properly where in when i tried to load it using datastage it is throwing same error.

I used the following function in datastage

Convert("'","''",MyString)

Could you please let me know your inputs.

[ArndW]

Output 2 new columns to test - Len(In.Col) and Len(Trim(In.Col)). Both should be equal and 9 for "M'Sateesh"

[sateeshbabu]

Hi ArndW,

I tried in such a way you told but the same thing is happening,

The length i am getting from input is 9 when i use len(Col) ,and both my output and input column lengths are same.