Re: [sqlite] escape quote for csv import

te for csv import On Jun 18, 2013, at 10:46 PM, Roland Hughes <rhug...@cincinnati-test.com> wrote: > It isn't documented anywhere, but, you have to BOTH quote the string AND > double up the quotes inside of it. Indeed: 7. If double-quotes are used to enclose fields, then a double-

Re: [sqlite] escape quote for csv import

Actually, I found the "correct" solution for the version of SQLite3 bundled with Linux Mint13 KDE. 2in|"2""" It isn't documented anywhere, but, you have to BOTH quote the string AND double up the quotes inside of it. Something like this should be documented in the FAQ or on the home page. I

Re: [sqlite] escape quote for csv import

Not an option, but thanks for the suggestion. From: sqlite-users-boun...@sqlite.org on behalf of Clemens Ladisch Sent: Tuesday, June 18, 2013 4:02 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] escape quote for csv import Roland Hughes wrote: >

[sqlite] escape quote for csv import

I'm sure this question has been asked a thousand times, but I did not find a useable answer anywhere on the web. How does one escape a in a CSV file so it will correctly import? I have data coming from a translation database. No, I cannot go fix the database, I can only massage the CSV and

Re: [sqlite] Correct way to open multiple in memory databases

of Richard Hipp Sent: Friday, May 24, 2013 1:27 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Correct way to open multiple in memory databases On Fri, May 24, 2013 at 1:14 PM, Roland Hughes <rhug...@cincinnati-test.com>wrote: > I have whatever came with Qt 4.8.x and L

Re: [sqlite] Correct way to open multiple in memory databases

e: > On Fri, May 24, 2013 at 5:03 PM, Roland Hughes > <rhug...@cincinnati-test.com>wrote: > >> "file:memdb1?mode=memory=shared", >> >> It ends up creating files in the executable directory. > > Have you tried using ":memory:"? Each insta

Re: [sqlite] Correct way to open multiple in memory databases

in memory databases On Fri, May 24, 2013 at 11:03 AM, Roland Hughes <rhug...@cincinnati-test.com > wrote: > All, > > I'm looking for the correct way to build a string (within Qt) to open > multiple in memory databases. The example here: > > http://www.sqlite.org/inmemorydb.

[sqlite] Correct way to open multiple in memory databases

All, I'm looking for the correct way to build a string (within Qt) to open multiple in memory databases. The example here: http://www.sqlite.org/inmemorydb.html Does not appear to work. "file:memdb1?mode=memory=shared", It ends up creating files in the executable directory. Thanks, Roland

Re: [sqlite] Writing in a blob

013, at 5:26pm, Stephen Chrzanowski <pontia...@gmail.com> wrote: > > > ALL THAT SAID, I doubt it'd get implemented > > I'm also in this category. In fact I hope it doesn't get implemented. Yes, > technically it can be done. But it's the sort of thing people assign a

Re: [sqlite] Writing in a blob

gt; not MVCC like Oracle, but the ability to at least not overwrite the whole > blob when changing 1 byte would be great. (I'm assuming there isn't, but > I'm no SQLite expert). My $0.02. --DD > ___ > sqlite-users mailing list > sqlite-users

Re: [sqlite] 64bit compatibility warnings

The short answer would be no. It has been some time since I looked at the MS compiler, but, int and int64 are two entirely different data types...unless you use a compiler switch to FORCE 64-bit data types int is 32-bit and int64 is 64-bit.

Re: [sqlite] 64bit compatibility warnings

s not released if a test fails. So, the warnings can be > ignored. > Or, it could be the tests simply don't exercise those possibilities. I've been in IT far too long to trust that a test suite is "complete". -- Roland Hughes, President Lo