character encoding - c# lotus dbase ODBC charset -
I am trying to read a lotus dbase file in exporting order data. I am using this code:
Here the code is private zero ODBC (login) {DataTable YourResultSet = New DataTable (); String strAccessConn = @ "driver = {Microsoft dBase driver (* .dbf)}; SourceType = DBF; SourceDB = C: \ shares \ lotus, exclusive = no; zero = not remove = no; BACKGROUNDFETCH = no; charset = 928" ; OdbcConnection Connection = New OdbcConnection (strAccessConn); // Open the connection, and if you open successfully, you can try asking it for connection. Open (); If (connection.State == ConnectionState.Open) {string mySQL = @ "Select from C: \ shares \ lotus \ techtime.DBF"; // DBF Table Name Odbc CommandsMyquery = New ODBC Commands (MySQL, Connection); OdbcDataAdapter DA = New OdbcDataAdapter (MyQuery); DA.Fill (YourResultSet); Connection.Close (); } String mystring = YourResultSet.Rows [0] [4]. Ostring (); }
But the Greek divisor looks like this "╠┴═╧╙ ═╔╩╧╦╧╒─╟╙" I do not know what the pigment has been used to do I can? Thank you in advance
You should use 737 code pages in your connection string:
; CHARSET = 737
Comments
Post a Comment