how to save and fetch string into Unicode in sql server

Question

hi folks how to save string into unicode format into sql server .and how to fetch and bind gridview into originial format. Please share some some link. Thank you in advance

Abhijit Patil · Answer

Hi Rajiv & Khargesh Rajput  Thank you for quick reply .I solve my problem.can you please tell me how i convert my text into multiple languages .means if i enter text as ?????? . i want to convert into multiple langues . Please share some link Thank you in advance.

Khargesh Rajput · Answer

use ntext datatype to column you want to save unicode data and insert by query

Rajeev Ranjan · Answer

private string BytesToString(byte[] Bytes) { MemoryStream MS = new MemoryStream(Bytes); StreamReader SR = new StreamReader(MS); string S = SR.ReadToEnd(); SR.Close(); return S; } private string ToUnicode(string S) { return BytesToString(new UnicodeEncoding().GetBytes(S)); }