[sqlite] how to write line feed "\n\r" when output a txt file

when I use : .output akk.txt select * from dhq where qph>0; .output stdout command to write a txt file,I found no "\n\r" in the each line , how to write "\n\r" each line in the output txt file? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] store db from sqlite to online mysql or online sqlite

On May 12, rebornishard wrote: i browse but didn't find it there is 5 apps running sqlite and they will export it intoonline mysql or online sqlite database search from doc but still didn't get anything thanks Your question is unclear, which is likely why it has not been answered. I am

Re: [sqlite] Is it possible to determine the length of UNICODE(UTF-8 or UTF-16) strings stored in SQLite 3.7.11 database?

On 13 May 2012, at 6:26pm, Richard Hipp wrote: > sqlite> select length('Gödel'), length(CAST('Gödel' AS blob)); > 5|6 > > SQLite does not know how to convert unicode to upper or lower case because > case conversion is locale dependent. But the number of characters in a >

Re: [sqlite] SQLite fow winrt metro application

On 13.05.2012 15:16 Simon Slavin said the following: On 13 May 2012, at 12:33pm, Michael Steiger wrote: On 13.05.2012 13:24 Simon Slavin said the following: On 13 May 2012, at 12:19pm, Ofer Ebert wrote: I need to handle an sql database in

Re: [sqlite] Is it possible to determine the length of UNICODE(UTF-8 or UTF-16) strings stored in SQLite 3.7.11 database?

On Sun, May 13, 2012 at 1:18 PM, Simon Slavin wrote: > > On 13 May 2012, at 4:49pm, Roger Binns wrote: > > > You should be accessing things via SQL and the C API. In that case the > > encoding in the database is not relevant as the strings have

Re: [sqlite] Is it possible to determine the length of UNICODE(UTF-8 or UTF-16) strings stored in SQLite 3.7.11 database?

On 13 May 2012, at 4:49pm, Roger Binns wrote: > You should be accessing things via SQL and the C API. In that case the > encoding in the database is not relevant as the strings have their > encoding converted as appropriate. > > sqlite3_column_bytes and

Re: [sqlite] SQLite fow winrt metro application

On Sun, May 13, 2012 at 12:34 PM, Pavel Ivanov wrote: > >>> Download the SQLite C amalgamation library from > >> Quick response as always but not relevant for C# > > > > Please explain why so I can provide accurate information in future. A > good JavaScript interface is

Re: [sqlite] SQLite fow winrt metro application

>>> Download the SQLite C amalgamation library from >> Quick response as always but not relevant for C# > > Please explain why so I can provide accurate information in future.  A good > JavaScript interface is SQLite3-WinRT.  The OP specified C#.  How would one > do it from C# under WinRT ?

Re: [sqlite] Is it possible to determine the length of UNICODE(UTF-8 or UTF-16) strings stored in SQLite 3.7.11 database?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 13/05/12 08:07, Frank Chang wrote: > Good Morning, Is it possible to determine the length of UNICODE(UTF-8 > or UTF-16) strings stored in SQLite 3.7.11 database? http://www.sqlite.org/fileformat.html You should be accessing things via SQL and the

Re: [sqlite] Is it possible to determine the length of UNICODE(UTF-8 or UTF-16) strings stored in SQLite 3.7.11 database?

> Good Morning, Is it possible to determine the length of UNICODE(UTF-8 or UTF- > 16) strings stored in SQLite 3.7.11 database? >I just tried using the IBM open-source ICU function int32_t u_strlen(const > UCHAR* str) but it gives me erroneous? Evidently the u_strlen function for a > UTF-8

[sqlite] Is it possible to determine the length of UNICODE(UTF-8 or UTF-16) strings stored in SQLite 3.7.11 database?

Good Morning, Is it possible to determine the length of UNICODE(UTF-8 or UTF-16) strings stored in SQLite 3.7.11 database? I just tried using the IBM open-source ICU function int32_t u_strlen(const UCHAR* str) but it gives me erroneous? Evidently the u_strlen function for a UTF-8 NULL

Re: [sqlite] SQLite fow winrt metro application

On 13 May 2012, at 12:33pm, Michael Steiger wrote: > On 13.05.2012 13:24 Simon Slavin said the following: >> >> On 13 May 2012, at 12:19pm, Ofer Ebert wrote: >> >>> I need to handle an sql database in my metro application (Windows 8) can I >>>

Re: [sqlite] SQLite fow winrt metro application

On 13.05.2012 13:24 Simon Slavin said the following: On 13 May 2012, at 12:19pm, Ofer Ebert wrote: I need to handle an sql database in my metro application (Windows 8) can I do it and how I use it from a c# application. Download the SQLite C amalgamation library

Re: [sqlite] SQLite fow winrt metro application

On 13 May 2012, at 12:19pm, Ofer Ebert wrote: > I need to handle an sql database in my metro application (Windows 8) can I > do it and how I use it from a c# application. Download the SQLite C amalgamation library from and

[sqlite] SQLite fow winrt metro application

Hi I need to handle an sql database in my metro application (Windows 8) can I do it and how I use it from a c# application. Thanks Ofer ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] index creation for single-use DB

On Sun, May 13, 2012 at 11:02:54AM +0300, Baruch Burstein wrote: > I am using an in-memory DB to load data into it, do a few sort / find > duplicates / SELECTs, and then dispose of the DB. It can vary in size from > a few thousand rows to over a million. > Would the time used for creating an index

[sqlite] index creation for single-use DB

I am using an in-memory DB to load data into it, do a few sort / find duplicates / SELECTs, and then dispose of the DB. It can vary in size from a few thousand rows to over a million. Would the time used for creating an index be worth it for just a single sort and a few SELECTs? If so, would it be

Re: [sqlite] Is it possible to insert UTF-8 strings in SQLITE3.EXE?

Richard Hipp, Simon Slavin, Luuk, and Keith Metcalf Thank you for your replies to our question. Here is another way I found out how insert UTF-8 strings in SQLITE3.EXE. F:\sqlite3_6_16>sqlite3.exe mdName.dat SQLite version 3.6.16 Enter ".help" for instructions Enter SQL statements