I use a SQL server 2000 to store data in local language (gb and Shift-JIS). I can successfully store the data into database, but when i retrieve back from database, i only get "?" in my asp program.

[quoted text, click to view]

What type is the column?

It sounds like you're probably accessing the data incorrectly in ASP.
I've seen problems like this before, but usually the other way round,
where data has been incorrectly written to the database in ASP, and
then .NET is (correctly) showing the dodgy data.

If Query Analyzer shows the data correctly, I'd suggest asking again on
an ADO or ASP newsgroup.

--
Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet