转换的SQL Server varbinary数据到串C＃ [英] Converting SQL Server varBinary data into string C#

问题描述

我需要帮助搞清楚如何从一个 SQL Server的设置为表列进来的数据转换 VARBINARY（最大）为一个字符串，以显示它在一个标签

I need help figuring out how to convert data that comes in from a SQL Server table column that is set as varBinary(max) into a string in order to display it in a label.

这是在 C＃和我使用的的DataReader

我可以拉在使用数据：

var BinaryString = reader[1];

我知道，这列认为是previously转换为二进制文本。

i know that this column holds text that was previously convert to binary.

推荐答案

这真的取决于，当您最初从字符串转换为二进制文件使用的编码：

It really depends on which encoding was used when you originally converted from string to binary:

 byte[] binaryString = (byte[])reader[1];

 // if the original encoding was ASCII
 string x = Encoding.ASCII.GetString(binaryString);

 // if the original encoding was UTF-8
 string y = Encoding.UTF8.GetString(binaryString);

 // if the original encoding was UTF-16
 string z = Encoding.Unicode.GetString(binaryString);

 // etc

这篇关于转换的SQL Server varbinary数据到串C＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！