Thursday, March 8, 2012

Chinese characters

:|Hello,
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)

>From the asp.net page form field, If I input chinese characters, the
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/ShowPo...ostID=2892#2948
Hope it helps

No comments:

Post a Comment