Displaying Hebrew text in ASP

Question

I am working on ASP application that reads data from sql server and displays it in a table. All my Hebrew text is replaced with "?????".

I installed and Configured Hebrew Font in Regional options. I have set the appropriate Charset in Head,Meta tag I am able to see proper Hebrew text in sqlServer2005ManagementSudioExpress. I have proper collation set for my Column (SQL_Latin1_General_CP1255_CI_AS) which is Hebrew. I still see "?????" isntead of Hebrew text.

Did I miss something ?

Answer 1

Make sure the column is set to store Unicode. For example, nvarchar instead of varchar, or ntext instead of text.