How to varbinary convert in string for mvc

Question

hai. How to varbinary convert in string for mvc

Midhun T P · Answer

Hi, You need to convert varbinary to string? Please try below code - 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); String to binary - System.Text.ASCIIEncoding encoding = new System.Text.ASCIIEncoding(); byte[] newByte = encoding.GetBytes(yourstring);

Tejas Trivedi · Answer

Hello Barathi, Varbinary is basically a byte array.Unicoding.Unicode.GetString() method help you to convert byte[] to string. Below code snippet help you covert varbinary to string. I assume your endcoding is UTF-8. byte []varbinarydata=( byte [])reader[1]; //iftheoriginalencodingwasUTF-8 string data =Encoding.Unicode.GetString( varbinarydata ); Hope, this will help you out. Feel free to write if more information is required. Please don't forget to mark as answer if this helps.

How to varbinary convert in string for mvc

Answers (2)