encoding question: read shift-JIS data from database

[jani]

Hi,
i am using a database which contains kanji characters with shift-jis
encoding, and i want to show the characters in a datagrid.

Now i am using a sqldataset as data source, and show the data in a
asp.net datagrid. The problem ist, the characters can not be shown
properly.

could anyone telle me how to read the data from the database if they
are encoded in shift-jis?

thanks

jani

 

[Jon Skeet [C# MVP]]

i am using a database which contains kanji characters with shift-jis
encoding, and i want to show the characters in a datagrid.

Now i am using a sqldataset as data source, and show the data in a
asp.net datagrid. The problem ist, the characters can not be shown
properly.

could anyone telle me how to read the data from the database if they
are encoded in shift-jis?

Are you sure that the problem is in getting the data from the database?
You should check it at each stage in the process. When you've got the
data from the database, write each character out as an integer and
compare it with the code charts on www.unicode.org.