Thanks all. I'll consider this thread done. With Ryan and Bills comments,
I've decided that I'll truck on as is, and not worry about special string
considerations.
Thinking about how Delphi Berlin is handling strings at the compiler level,
and how the wrapper I use is handling the strings based
Hello,
On 2018-02-20 23:59, Etienne Sanchez wrote:
Some other DBMS such as Postgres and SQL-Server implement the functions
"left" and "right". SQLite does not. But why do I get confusing error
messages when I (mistakenly) attempt to use them?
To illustrate my point:
select foo('abc', 2)
Error
On 2/20/18, Etienne Sanchez wrote:
>
> As for "left", it's maybe due to the ambiguity with "left join", but then
> what about "right"? (There is no ambiguity with "right join" since it is
> not supported.)
"left" and "right" are keywords in SQL. SQLite understands the RIGHT
keyword, even though
Hi,
Some other DBMS such as Postgres and SQL-Server implement the functions
"left" and "right". SQLite does not. But why do I get confusing error
messages when I (mistakenly) attempt to use them?
To illustrate my point:
select foo('abc', 2)
Error: no such function: foo
select left('abc', 2)
Er
On 02/14/2018 09:13 PM, Joshua Watt wrote:
Hello,
I observed the following behavior when using the wal_checkpoint PRAGMA
in TRUNCATE mode:
SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a
> What I'm interested in finding out, without changing my code at this time, is
> if
> SQLITE3.EXE is handling things differently than what SQLite Expert is.
It absolutely is. I am a heavy user of SQLite Expert and was stumped by weird
problems in my databases until I realized the SQLite Expert
On 2018/02/20 6:35 PM, Richard Hipp wrote:
All that said, I'm not exactly sure what you are asking.
I had some trouble with that too, but I think his question boils down to:
Considering that SQLiteExpert is doing seemingly funny things under the
hood on top of SQLite, would those be safe
On Tue, Feb 20, 2018 at 11:44 AM, Jens Alfke wrote:
>
>
> > On Feb 19, 2018, at 7:49 PM, petern wrote:
> >
> > 3. Why can't SQLite have the expected common static SQL functions for
> > getting rapid development done without external tools?
>
> Because its primary use case is as an embedded libra
> On Feb 19, 2018, at 7:49 PM, petern wrote:
>
> 3. Why can't SQLite have the expected common static SQL functions for
> getting rapid development done without external tools?
Because its primary use case is as an embedded library for programs, not as a
standalone tool or server. From that pe
On 20 Feb 2018, at 4:21pm, Stephen Chrzanowski wrote:
> What I'm not entirely sure of is whether SQLite Expert is understanding and
> handling the BLOB_TEXT field and just not doing the actual query to get the
> text, or, if it understand if there is some kind of special handling that
> SQLite Ex
I'm absolutely clear that the SQLite3 developers have absolutely NOTHING to
do with SQLite Expert. I apologize if there was any indication that I was
thinking that I was asking for the devs of SQLite3 would have a direct
answer to how that 3rd party tool works.
My hope was that someone who uses S
At 17:35 20/02/2018, you wrote:
SQLite Expert, if I am not mistaken, does
try to do some magic under the hood to make SQLite function more like
how the SQLite-Expert authors think it should function, rather than
how it actually functions. So your theory of the difference in output
being due to s
One thing that it is important to be clear on is that SQLite Expert is
a 3rd-party product that is not supported nor even understood by the
official SQLite developers. SQLite Expert, if I am not mistaken, does
try to do some magic under the hood to make SQLite function more like
how the SQLite-Exp
Well, according to the standard that field should have a text affinity.
http://www.sqlite.org/datatype3.html#determination_of_column_affinity
And using single quotes makes what you're giving it text values rather than
blobs
http://www.sqlite.org/lang_expr.html
"A string constant is formed by en
That was NOT supposed to happen. :P
CREATE TABLE [Test](
[ID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[T1] TEXT,
[T2] BLOB_TEXT);
insert into Test (T1,T2) values ('Test 1','Test 2');
In SQLite Expert, it hides "Test 2" as a (blob). I'm fine with that.
In SQLITE3.exe, it shows "T
I'm fully aware that any kind of data can be stored in any kind of field.
Strings can be in integer declared fields, etc.
What I'm interested in finding out, without changing my code at this time,
is if SQLITE3.EXE is handling things differently than what SQLite Expert is.
In "SQLite Expert", if
On Mon, Feb 19, 2018 at 7:49 PM, petern wrote:
> There are other uses for padding strings besides user reports. Consider
> scalar representations of computations for example. Also:
>
> 1.There was no mention of user display formatting in Ralf's original
> report. It was a bug report about missi
On Wed, 2018-02-14 at 08:13 -0600, Joshua Watt wrote:
> Hello,
>
> I observed the following behavior when using the wal_checkpoint
> PRAGMA
> in TRUNCATE mode:
>
> SQLite version 3.22.0 2018-01-22 18:45:57
> Enter ".help" for usage hints.
> Connected to a transient in-memory database.
> Use ".op
There are other uses for padding strings besides user reports. Consider
scalar representations of computations for example. Also:
1.There was no mention of user display formatting in Ralf's original
report. It was a bug report about missing inverse functionality for
padding/trimming strings.
2.T
19 matches
Mail list logo