Code Page Conversion?
Code page of my DB2 database on AS400 is IBM037. My windows code page is 1250. Windows controls do not display data corectly becouse of bad or no conversion. Driver for accesing data is DataDirect for .Net. Non English letters don't display corectly.
OS: Microsoft Windows Professional SP2.
ADO.NET: version 2.0.
Connection string is: "Host=10.1.1.11 ; Port=446 ; User ID=userID ; Password=pass ; Database=S33G2003 ; Collection=DB; Charset For 65535=IBM037".
Database work:
DataTable myDataTable
DB2Connection myConnection = new DB2Connection(ConnectionString)
try { myConnection.Open(); }
catch (DB2Exception es)
{ MessageBox.Show("Error " + es.Message); }
DB2Command myCommand = myConnection.CreateCommand();
myCommand.Connection = myConnection;
try
{
myCommand.CommandText = "SELECT * FROM myTable";
DB2DataReader myDataReader = myCommand.ExecuteReader();
myDataTable.Load(myDataReader);
}
catch (DB2Exception ex)
{ MessageBox.Show(ex.Message); }
try { myConnection.Close(); }
catch (DB2Exception es)
{ MessageBox.Show(es.Message); }
I need help to solve this problem.
Thanks
