How can I specify the character encoding to be used by OLEDB when querying a DBF?

Posted by Manga Lee on Stack Overflow See other posts from Stack Overflow or by Manga Lee
Published on 2009-09-25T06:58:45Z Indexed on 2010/04/11 13:03 UTC
Read the original article Hit count: 379

Filed under:

oledb

|

dbf

|

character-encoding

|

ADO.NET

|

.NET

Is it possible to specify which character encoding should be used by OLEDB when querying a DBF file?

A possible work-around would be to encode the query string before the OLEDB call to the DBF file's character encoding and then encode all the results when they are returned. This will work but it would be nice if OLEDB or possibly ADO.NET could do this for me.

UPDATE

The suggestion by Viktor Jevdokimov does not seem to work automatically. But it made me investigate manual conversion of the strings. It is possible to use the TextInfo property of CultureInfo to find out the OemCodePage and the WindowsCodePage and use those to get the corresponding Encoding instances to perform manual conversion. But I can not get ADO.NET use these encondings to perform the conversion for me.

© Stack Overflow or respective owner

Related posts about oledb

Running OLEDB VB6 Windows Progam Under Wine

as seen on Super User - Search for 'Super User'
I'm trying to install a VB6 Windows program that uses OLEDB to access VFP tables to run under Wine 1.0.1 on Ubuntu 9.10. Wine is configured to Windows version Windows XP. The program install ran okay, and I used winetricks to install MDAC 2.8 and JET 4.0 sp7. I also installed Microsoft's vfpoledb… >>> More
Using OLEDB parameters in .NET when connecting to an AS400/DB2

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been pulling my hair out trying to figure out what I can't get parameters to work in my query. I have the code written in VB.NET trying to do a query to an AS/400. I have IBM Access for Windows installed and I am able to get queries to work, just not with parameters. Any time I include a parameter… >>> More
How to determine MS Access field size via OleDb

as seen on Stack Overflow - Search for 'Stack Overflow'
The existing application is in C#. During startup the application calls a virtual method to make changes to the database (for example a new revision may need to calculate a new field or something). An open OleDb connection is passed into the method. I need to change a field width. The ALTER TABLE… >>> More
OleDb database to DataSet and back in c#?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a program that lets a user: Connect to an (arbitrary) View all of the tables in that database in separate DataGridViews Edit them in the program, generate random data, and see the results Choose to commit those changes or revert So I discovered the DataSet class, which looks like it's… >>> More
Exception:Cannot Start your application.The Workgroup information file is missing or opened exclusiv

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We were getting this error when trying to connect to a password protected access file. This is what the connection string looked likestring conString =@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="Path to your access file";User Id=;Password=password";To fix the issue this is what… >>> More

Related posts about dbf

Reading DBF with VFPOLEDB driver problem.

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using VFPOLEDB driver to read DBF files and I keep getting this error and I am not sure why and how to fix the problem: The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet… >>> More
C#+BDE+DBF problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have huge problem: I have lots of .dbf files(~50000) and I need to import them into Oracle database. I open conncection like this: OleDbConnection oConn = new OleDbConnection(); OleDbCommand oCmd = new OleDbCommand(); oConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="… >>> More
Packing a DBF

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I thought my days of dealing with DBFs as a "production data" source were over, but HA (no such luck). I recently had to retrieve, modify and replace some data that needed to be delivered in a DBF file. Everything was fine until I realized / remembered the DBF driver does not ACTUALLY delete records… >>> More
Packing a DBF

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I thought my days of dealing with DBFs as a "production data" source were over, but HA (no such luck). I recently had to retrieve, modify and replace some data that needed to be delivered in a DBF file. Everything was fine until I realized / remembered the DBF driver does not ACTUALLY delete records… >>> More
Advanced TSQL Tuning: Why Internals Knowledge Matters

as seen on SQL Blog - Search for 'SQL Blog'
There is much more to query tuning than reducing logical reads and adding covering nonclustered indexes. Query tuning is not complete as soon as the query returns results quickly in the development or test environments. In production, your query will compete for memory, CPU, locks, I/O… >>> More