C# - 解码 AS/400 iSeries 中的数据

发布于 2024-07-16 08:53:06 字数 482 浏览 7 评论 0原文

我正在使用标准 .NET OdbcConnection 连接到 AS/400 iSeries 数据库。我可以查询这个数据库。不幸的是，有些字段似乎已被编码。如何在 C# 中解码这些值？我尝试过以下操作：

string text = string.Empty;
if (bytes.Length > 0)
{
    ASCIIEncoding encoder = new ASCIIEncoding();
    text = encoder.GetString(bytes);
}
return text;

bytes 变量表示需要解码的数据。不幸的是，我没有任何运气。有人告诉我，如果我在 Windows 计算机上设置 ODBC 数据源并选中翻译选项卡中的“将二进制数据 (CCSID65535) 转换为文本”复选框，则数据将正确返回。但是，我想使用纯 C#。有任何想法吗？我还差得远吗？

谢谢！

原文

I am using the standard .NET OdbcConnection to connect to an AS/400 iSeries database. I am able to query this database. Unfortunately, there are some fields that appear to be encoded. How do I decode these values in C#? I have tried the following:

string text = string.Empty;
if (bytes.Length > 0)
{
    ASCIIEncoding encoder = new ASCIIEncoding();
    text = encoder.GetString(bytes);
}
return text;

The bytes variable represents the data that needs to be decoded. Unfortunately, I am not having any luck. I have been told that the data will return correctly if I setup an ODBC data source on my Windows machine and check the "Convert binary data (CCSID65535) to text" checkbox in the translation tab. However, I want to use pure C#. Any ideas? Am I way off?

Thanks!

分享到QQ

分享到微博