OleDbConnection / Command for DB with locale-specific character

I have an MS Access DB with a table that contains Columns that have Names with Danish characters. egDøbt

When the program works on a PC with a Danish location, everything works fine, but on a PC with a Ukrainian location, I got an error when the field is Dbtmissing. It seems that char øcomes to me from the DB as

The code that causes the error in the last line:

var connection = new OleDbConnection();
connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\STAT.MDB";
var table = new DataTable( "NewTable" );
table.Locale = CultureInfo.GetCultureInfo( "da-DK" ); 
var adapter = new OleDbDataAdapter( "SELECT Døbt FROM Table", connection );
adapter.Fill( table );

Is there a way to set a target culture for connectivity or something else?

+3
source share
1 answer

, , , , , , , ,

+1

All Articles