c# lotus dbase ODBC charset

本文关键字:charset ODBC dbase lotus | 更新日期: 2023-09-27 18:26:53

我正在尝试读取 lotus dbase 文件以导出数据。我正在使用此代码:

enter code here
    private void odbc()
    {
        DataTable YourResultSet = new DataTable();
        string strAccessConn = @"Driver={Microsoft dBase Driver (*.dbf)};SourceType=DBF;SourceDB=C:'shares'lotus;Exclusive=No;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;CHARSET=928";
        OdbcConnection connection = new OdbcConnection(strAccessConn);
        // Open the connection, and if open successfully, you can try to query it
        connection.Open();
        if (connection.State == ConnectionState.Open)
        {
            string mySQL = @"select * from C:'shares'lotus'techtime.DBF";  // dbf table name
            OdbcCommand MyQuery = new OdbcCommand(mySQL, connection);
            OdbcDataAdapter DA = new OdbcDataAdapter(MyQuery);
            DA.Fill(YourResultSet);
            connection.Close();
        }
        string myString = YourResultSet.Rows[0][4].ToString();
    }

但希腊语的莱特斯是这样的"╠┴═╧╙ ═╔╩╧╦╧╒─╟╙"我不知道使用了字符集。我能做什么?提前致谢

c# lotus dbase ODBC charset

应在连接字符串中使用 737 代码页:

;CHARSET=737