After a long search, I found this article i thought to solve my
problem.

I am using Win 2000 Advanced Server, SQL Server 2000 standard edn.
dotNET F/W 1.1

My table structure is

empid      integer
empname    varchar(30)
empname_chinese nvarchar(20)

chinese characters are displayed as ??? 40 ???(after 40 days)

Whats the problem.

i am really disgusted with this. I am searching a lot in google. But
still didnt solve.

Can anyone please help me to solve my problem?

I've changed the <globalization fileEncoding="utf-8" ...> in web.config
also

still no use.

Any help is highly appreciated.

I am inserting into my database table from web form as

"insert into employee(empid,empname,empname_chinese)
values(@empid,@empname,@empname_chinese)"

dbcommand.parameters.add(new
SqlParameter("@empname_chinese",sqlDBType.NVarchar)).value=txtNameChin.text
........

dbcommand.executeNonQuery()

connection and all statements skipped for explanation.

http://sqljunkies.com/Forums/ShowPost.aspx?PostID=2892#2948

Hope it helps

can't delete a row from primary table - is there an SP for this?
Ranking Rows
T-SQL
simple trigger question
UDFs - what resources used?