Re: [sqlite] Re: Re: Why are strings in hexadecimal notation always blobs?

2008-01-18 Thread Nicolas Williams
On Sat, Jan 19, 2008 at 03:23:32AM +0700, Lothar Scholz wrote: > IT>Does this really make sense to you? > > Yes the only reason left for a BLOB would be a containing zero byte and > any illegal UTF8 sequence of bytes. Or wanting to avoid collations that are aware of, say, Unicode

Re: [sqlite] Re: Re: Why are strings in hexadecimal notation always blobs?

2008-01-18 Thread Lothar Scholz
Hello Igor, Saturday, January 19, 2008, 12:02:15 AM, you wrote: IT> You misunderstand the dynamics of datatypes then. Yes maybe. With the current implementation i really do not understand the point anyway neither with my understanding nor with yours. IT> Wait a minute. Didn't you just say that

[sqlite] Re: Re: Why are strings in hexadecimal notation always blobs?

2008-01-18 Thread Igor Tandetnik
Lothar Scholz wrote: Friday, January 18, 2008, 8:09:02 PM, you wrote: Lothar Scholz wrote: it seems that "Lothar" is stored as a TEXT value but when i store X'4C6F74686172' it is a BLOB. What is the reason for it? Same reason 1 is an integer literal but '1' is a string literal.