Re: [sqlite] pragma table_info(database.table) not supported

2013-03-22 Thread Peter Haworth
I found the code in the two attached files (are they allowed on this list?) on the web a while back. The claim was that it created an information schema database from an sqlite db. I know nothing about Lua but I managed to get as far as creating the schema. Unfortunately, the url I got it from

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-22 Thread Simon Slavin
On 21 Mar 2013, at 5:41pm, Peter Haworth p...@lcsql.com wrote: I found the code in the two attached files (are they allowed on this list?) You can't attach things to messages to this list. Thanks for finding the code. I think it's interesting as a talking point but we don't actually need to

Re: [sqlite] Problem getting utf-8 text out of a text column

2013-03-22 Thread Tim Streater
On 21 Mar 2013 at 23:30, Richard Hipp d...@sqlite.org wrote: On Thu, Mar 21, 2013 at 6:52 PM, Tim Streater t...@clothears.org.uk wrote: I have a column defined as TEXT and I insert utf-8 text into it. In particular, there are byte sequences that might look as follows: ... 74 6F 20 C2 A3 32

Re: [sqlite] Problem getting utf-8 text out of a text column

2013-03-22 Thread Simon Slavin
On 22 Mar 2013, at 3:04pm, Tim Streater t...@clothears.org.uk wrote: Having checked the db carefully, both using hex(col) (via the sqlite3 CLI program), and using the unix hexdump utility on the db, I'm now reasonably certain that the C2 bytes are simply not in the db. That they show up