Problem in retrieve data from SQL server using OLEDB

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.
 
J

Jon Skeet [C# MVP]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 2
Sql2000 storing and retrieve checkbox value.. 2
Convert Encoding from Shift-JIS to UTF-8 5
Save c# objects in sql server 2008 3
Retrieve data from Access database and fill data in form 0
Sql server deadlock retry 6
Store XML/XSD in SQL Server 2008 3
Connecting to a SQL Server 2005 (Express Edition) database 3

Top