I am a developer in HK
I have input my data using a web page to a access database, the CHINESE char is encoded in unicode

When I want to search the DB using
"SELECT * FORM DBNAME WHERE name="CHINESE CHAR"
I can't search anything

But when I search
"SELECT * FORM DBNAME WHERE name="unicode of that CHINESE CHAR"
I can search the result

Can any one tell me how can I change the input text from web to unicode automatically

Thanks!!

Check this out...

http://codelib.aspemporium.com/index.aspx?pid=114&cid=3

Tim