Character conversion issue

dataservices job design
1

Hi,

We are experiencing an issue whereby a double quote character (seems to be a special character) stored in a SQL Server 2012 database is being converted to ‘?’ when reading data from the table in DS.

It looks like this is a code page issue, but even setting the code page in the datastore to what the SQL Server database is using is not resolving the issue. The collation of the SQL Server 2012 database is ‘Latin1_General_100_bin’. I believe this translated to a code page of 1252. In the datastore we set the code page to cp1252 to see if this resolves the issue. However, the data retrieved from the source still converts the double quotes to ‘?’.

Has anyone experienced this and know how to resolve this?

Thanks

Nilz07 (BOB member since 2007-05-22)

2

More information. When setting the code page to cp1252, the data does show correctly when looking at the data in the source table in DS Designer. Once we execute the job, it looks like the character gets convered to ‘->’ (another special character) symbol once it passes through the query transform. I have verified this in debug mode.

Nilz07 (BOB member since 2007-05-22)

3

Hi Neil,

Could you please check the below blog for your issue.

https://blogs.sap.com/2016/06/14/sap-ds-code-page-settings-steps/

Thanks & Regards,
Ramana.

Ramana :india: (BOB member since 2009-04-30)