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.