Thanks for helping!

I am using "IBM DB2 UDB for iSeries IBMDA400 OLE DB provider"

Everything goes ok for most of the tables. I am facing this problem only in some tables

As i have seen it has to do something with columns that contain names,surnames,addresses of people.

sorry but how can I check these two:

"Is the AlwaysUseDefaultCodePage property set to True on the AS400 Data Source Task?

Also examine the CCSID for column using the iSeries Navigator. Is it 37?"

I am doing everything from Sql Server Management Studio

Thanks