my application is ASP-ADO-SQL Server 2000. i want to store Japanese characters in one column. after i input, i can view those Japanese characters in SQL. it's correct. but when i use ADO to select and display the data at ASP page, all of the Japanese characters are replaced with question marks, says, '???????'. why?
on the other side, all is fine when i use SQL Server 7.0. in 7.0, those characters is view incorrectly, but display in ASP is no problem. anybody can help me to solve this problem?