How to convert characters in CCSID 65535

My application is in VB.Net and I'm using the driver of IBM Client Access to access data on our IBM iSeries server.

The problem is that some characters are not translated automatically in CCSID 65535 (i.e. the € character) and the update/insert comm开发者_JAVA技巧and fails.

I don't know on which level the problem must be handled. On the ODBC driver ? In the connection string ? Or do we have to create a conversion dll ?

Thanks in advance for your help !

Do you have BinAsChar=true set in the Connection String. You might also need to set either CCSID or Host CCSID to one that's valid for you, the default us 37 which is US/Canada. Here's more info on connection string parameters for DB2:

http://msdn.microsoft.com/en-us/library/ee251805%28BTS.10%29.aspx

Set up the DSN using the "iseries Access ODBC Driver" by using the Windows "ODBC Administration" tool. In the configuration setup, select the conversions tab and check the box "Convert binary data (CCSID 65535) to text.