Re: [sqlite] Accented characters and ODBC - Fixed

2010-10-07 Thread Greg Bryant
I had the right idea, but the wrong code page. So, going from MBCS project in visual c++, there is a magic ANSI to UTF8 conversion happening when the data is stored, but not one coming back out. I could not find a direct UTF8 to ANSI code page conversion, presumably since they are both

Re: [sqlite] Accented characters and ODBC

2010-10-07 Thread Greg Bryant
Still hoping someone can help me with this. I dug into it some with a hex editor, and it may be the app mode, which is multi-byte (and makes extensive use of libraries, so is not about to change). If I put the string Andé in, it is (41 6e 64 e9) in the debugger, but looking at the sqlite

Re: [sqlite] Accented characters and ODBC

2010-10-04 Thread Christian Werner
Greg Bryant wrote: > > Not sure if ODBC questions belong here, feel free to point me to a better > forum. > > I'm using current SQLite (3.7.2) via a visual c++ app. We're connecting a > sqlite3 database via ODBC (driver from , also current version - 0.87). If I > do either an insert or update

Re: [sqlite] Accented characters and ODBC

2010-10-01 Thread Oliver Peters
Greg Bryant writes: just saw that you usually should install 3 different ODBC-drivers and 1 of them is called SQLite ODBC (UTF-8) Driver. Maybe you should give it a try before asking the programmer greetings ___ sqlite-users

Re: [sqlite] Accented characters and ODBC

2010-10-01 Thread Oliver Peters
Greg Bryant writes: [...] > Does anyone have any pointers on where I can look to figure > this out? [...] maybe the friendly driver programmer is willing to help you if you send a bug report http://www.ch-werner.de/sqliteodbc/html/index.html greetings Oliver

Re: [sqlite] Accented characters and ODBC

2010-10-01 Thread Drake Wilson
Quoth Greg Bryant , on 2010-10-01 12:51:10 -0500: > I'm using current SQLite (3.7.2) via a visual c++ app. We're connecting a > sqlite3 database via ODBC (driver from Driver from where again? > When I go to do a select via the ODBC connection, however, I get back > garbage

[sqlite] Accented characters and ODBC

2010-10-01 Thread Greg Bryant
Not sure if ODBC questions belong here, feel free to point me to a better forum. I'm using current SQLite (3.7.2) via a visual c++ app. We're connecting a sqlite3 database via ODBC (driver from , also current version - 0.87). If I do either an insert or update using an accented character (e.g.