Microsoft.Jet.OLEDB.4.0 Converting Characters

by

Finally! Thanks to @HABJAN I was able to get to the resolution which is as simple as setting the CharacterSet in the Extended Properties of the connection string. For my situation it was UTF-8… commonly used by default in PHPMyAdmin which is where my data was retrieved from.

Resulting working connection string:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"{0}\";Extended Properties=\"text;HDR=Yes;FMT=Delimited;CharacterSet=65001;\""

Key is CharacterSet=65001 (Code Page Identifiers) which might have been obvious to some collation-savvy individuals but I’ve somehow managed to avoid these issues over the years and never come across it in this respect.

I was also able to get HABJAN’s solution to work when also following the documentation found at https://learn.microsoft.com/en-us/sql/odbc/microsoft/schema-ini-file-text-file-driver and setting the CharacterSet to the same as above.

For my situation, this is the better method as it is a simpler/more maintainable solution, but +1 to HABJAN for helping me get there!

Thanks

More Related Contents:

  1. Taking lot of time to read from SQL Server using c#
  2. Automated checking of database connection and query in same database [closed]
  3. Execute non-query error [closed]
  4. SQL Date format BETWEEN query
  5. Using Excel OleDb to get sheet names IN SHEET ORDER
  6. how to update a table using oledb parameters?
  7. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  8. LINQ to SQL multiple tables left outer join
  9. Passing List to SQL Stored Procedure
  10. Wildcard search for LINQ
  11. Map category parent id self referencing table structure to EF Core entity
  12. Get an IDataReader from a typed List
  13. Does using parameterized SqlCommand make my program immune to SQL injection?
  14. Entity Framework – stored procedure return value
  15. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  16. Direct method from SQL command text to DataSet
  17. encrypt SQL connectionstring c#
  18. Table name and table field on SqlParameter C#?
  19. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  20. How to make LINQ execute a (SQL) LIKE range search
  21. Could not find installable ISAM
  22. Get affected rows on ExecuteNonQuery
  23. Add WHERE clauses to SQL dynamically / programmatically
  24. How to use SQL ‘LIKE’ with LINQ to Entities? [duplicate]
  25. Query validation using C#
  26. C# SQL insert command
  27. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  28. Scientific notation when importing from Excel in .Net
  29. Querying data using Entity Framework from dynamically created table
  30. Capturing count from an SQL query

Leave a Comment