I only had just figured out a hack to get the .NET v1 provider to translate CCSID 65535 binary fields to text, and now I'm a bit lost again.
Is there a connection string setting, or some static property I can set to tell the provider that AS400/DB2 binary fields are text?
Pinned topic Force Translate in Connection String?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2005-12-20T17:44:04Z at 2005-12-20T17:44:04Z by SystemAdmin
bpgross 110000C99H627 Posts
Re: Force Translate in Connection String?2005-12-20T05:56:46ZThis is the accepted answer. This is the accepted answer.There is no force translate or similar option in the DB2 .NET data provider. I am aware of this requirement, but unfortunately we do not have a solution at this time.
SystemAdmin 110000D4XK2826 Posts
Re: Force Translate in Connection String?2005-12-20T17:44:04ZThis is the accepted answer. This is the accepted answer.
- bpgross 110000C99H
Anyhoo, ok, maybe even better than that would be a DB2 SQL function that converted binary text (65535) to plain old Windows text (37). I can do this after it is returned to the client, but it would be much cleaner to do it in the stored procedures.