Displaying Chinese characters on a web page.

Yes the column is nvarchar and the code I was given to work from is given below:

    protected void Page_Load(object sender, EventArgs e)

    {

            SqlConnection sqlConnection = new SqlConnection("Data Source=db4;Initial Catalog=db;UID=bd;PWD=bd;Max Pool Size=200;");

            sqlConnection.Open();

 

            byte[] bytes = HttpUtility.UrlDecodeToBytes("%BD%BB%D2%D7%D4%B1", Encoding.UTF8);

 

            string s = "BDBBD2D7D4B1";

 

            SqlCommand command = new SqlCommand("SELECT CAST(0x"+s+" as nvarchar(100))", sqlConnection);

            SqlDataReader reader = command.ExecuteReader();

            reader.Read();

            Response.Write(reader.GetString(0));

            reader.Close();

 

            sqlConnection.Close();

 

    }

This is not my code!!

How do you store the chinese characters in your database? What is the data field type. If I'm not mistaken, it should be of unicode type (nchar, nvarchar).

And how do you retrieve/display it on the webpage?