Re: [sqlite] Feature request: add support for COMMENT statement

On 18 Jun 2013, at 9:39pm, Stephen Chrzanowski wrote: > Just out of curiosity, either by including it as another SQLite built in > table, or, a user added table after the fact, couldn't a relationship be > built between the new table and a comment, or a field in a table and

Re: [sqlite] escape quote for csv import

On Jun 18, 2013, at 11:07 PM, Roland Hughes wrote: > and "tools.ietf.org" is exactly WHERE on the sqlite.org path? "Everything is amazing and nobody is happy" -- Louis CK ___ sqlite-users mailing list

Re: [sqlite] escape quote for csv import

and "tools.ietf.org" is exactly WHERE on the sqlite.org path? From: sqlite-users-boun...@sqlite.org on behalf of Petite Abeille Sent: Tuesday, June 18, 2013 5:03 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] escape quote for csv

Re: [sqlite] escape quote for csv import

On Jun 18, 2013, at 10:46 PM, Roland Hughes 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-quote appearing

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: > How

Re: [sqlite] Feature request: add support for COMMENT statement

Just out of curiosity, either by including it as another SQLite built in table, or, a user added table after the fact, couldn't a relationship be built between the new table and a comment, or a field in a table and comment be made? So for example (A very VERY loose example) create table

Re: [sqlite] escape quote for csv import

On Jun 18, 2013, at 10:02 PM, Clemens Ladisch wrote: > (There is no official CSV standard, and there is no widely supported > escaping mechanism.) Perhaps. But that's not an excuse to ignore the de facto convention: Common Format and MIME Type for Comma-Separated Values

Re: [sqlite] escape quote for csv import

On 6/18/2013 4:02 PM, Clemens Ladisch wrote: (There is no official CSV standard, and there is no widely supported escaping mechanism.) Well, there's http://tools.ietf.org/html/rfc4180 -- Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] escape quote for csv import

Roland Hughes wrote: > How does one escape a in a CSV file so it will correctly import? The sqlite3 tool allows to configure the separator, but the quote character for delimiting fields is hardcoded. (There is no official CSV standard, and there is no widely supported escaping mechanism.) > I

Re: [sqlite] How to get the longest common sequence using C

On 06/19/2013 02:17 AM, Stadin, Benjamin wrote: Hi, From the documentation on fts3 it is not clear to me how to access the longest common distance structure. Could you please provide an example how to calculate the offset to the stuct inside the match info? According to the docs I thought it

[sqlite] How to get the longest common sequence using C

Hi, >From the documentation on fts3 it is not clear to me how to access the longest common distance structure. Could you please provide an example how to calculate the offset to the stuct inside the match info? According to the docs I thought it should be something like this, but so far no luck:

[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] Feature request: add support for COMMENT statement

Dear fellow users and managers of SQLite, Alexey Pechnikov wrote: >Bad idea. The schema definition can't be modified! In fact it's possible if you use the writable schema pragma http://www.sqlite.org/pragma.html#pragma_writable_schema An application could drop all applicable `ls -l` and `id

Re: [sqlite] How to select from a temp table with same name as a main table.

On 17 June 2013 23:19, dochsm wrote: > I have a table in the main database called 'students' and a two page block of > sql that processes it, referring to it as simply 'students'. > > Experimenting with a different approach, I created a temp table, also called >

[sqlite] How to select from a temp table with same name as a main table.

I have a table in the main database called 'students' and a two page block of sql that processes it, referring to it as simply 'students'. Experimenting with a different approach, I created a temp table, also called 'students' that contained a subset of the main.students. (I intended to modify

Re: [sqlite] Feature request: add support for COMMENT statement

Hello! > Roman Fleysher Mon, 17 Jun 2013 09:14:59 -0700 > ... However, I do not understand why new > functionality of SQLite is needed. Why can't the mapper use a special table of > three columns (I will use example from Alexey): We can replace the "drop column" functionality by easy SQL script

[sqlite] Custom Ranking: How to get length of search word

Hi, I'm implementing a custom rank function which should give an exact match a higher score. So in the ranking function I get the length of the found matches via offsets(). But how can I get the length of the original match search word? match info() doesn't provide this. In addition, is it