How to use SQLite ODBC Driver with UTF-8 encoding? -


i downloaded , installed sqlite odbc driver http://ch-werner.de/sqliteodbc/. had 3 new odbc drivers in list

sqlite (utf-8) driver sqlite odbc driver sqlite3 odbc driver 

using sqlite3 odbc driver works fine. not utf-8.

the sqlite odbc (utf-8) driver assumed work in case gives me error message

fehler beim herstellen der verbindung zur datenquelle test   im002 [microsoft][odbc driver manager] data source name not found , no default driver specified fehler beim herstellen der verbindung zur datenquelle: test 

english translation:

error connecting data source test im002 [microsoft][odbc driver manager] data source name not found , no default driver specified error connecting data source test 

what doing wrong?

christian werner, provider of sqlite driver helped me via e-mail. turned out in settings of sqlite3 odbc driver oemcp translation has turned on (by clicking configure... of specific user dsn in odbc data source administrator)

now characters shown expected.


Comments