Re: [sqlite] Changing Database Encoding

2007-07-30 Thread Mitchell Vincent
Wow, it looks like I really did a number on these! I found iconv for Windows and have integrated it into the conversion process... NOw to tackled the Unicode handling (or non-handling) of the SQLite ODBC driver.. This will sure teach me to go around changing things! On 7/30/07, Nuno Lucas <[EMA

Re: [sqlite] Changing Database Encoding

2007-07-30 Thread Nuno Lucas
On 7/30/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: > I've read a few places that it is not possible to change the encoding > of a database once it's created. Is it possible to do it in some > automated way with any of the command line utilities? Read about the "pragma encoding" [1] SQL comman

[sqlite] Changing Database Encoding

2007-07-30 Thread Mitchell Vincent
I've read a few places that it is not possible to change the encoding of a database once it's created. Is it possible to do it in some automated way with any of the command line utilities? I converted a database from SQLite 2.X to 3.X using sqlite.exe's .dump function and apparently didn't set the