Problem in retrieve data from SQL server using OLEDB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.

Is there any solution? Thx for help.
 
simon said:
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.
Click to expand...

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.
 
Back
Top