-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/03/12 11:59, Marc L. Allen wrote:
> I use Navicat Lite, and it apparently treats an empty string as a NULL
> when displaying.
It is far more likely to display the empty string as an empty string and
to also display null as an empty string (by
> A good rule of thumb is that if you claim a bug in another component
> you are almost certainly wrong.
I don't have the command line version on this machine. I use Navicat Lite, and
it apparently treats an empty string as a NULL when displaying.
I always check my own code. I didn't expect
On 08-03-2012 20:48, Marc L. Allen wrote:
> Is that expected? To me, '' is different than NULL.
>
> create table a
> (
> a text
> );
>
> insert into a select '';
> select * from a;
>
> Is there a way to store an empty string?
>
insert into a values(null);
.nullvalue NULL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
A good rule of thumb is that if you claim a bug in another component you
are almost certainly wrong.
On 08/03/12 11:48, Marc L. Allen wrote:
> Is that expected? To me, '' is different than NULL.
They are indeed different.
> Is there a way to store
Where do you see NULL? I see empty string.
SQLite version 3.7.5
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table a (t text);
sqlite> insert into a select '';
sqlite> .nullvalue NULL
sqlite> select * from a;
sqlite>
Pavel
On Thu, Mar 8, 2012 at
On Mar 8, 2012, at 1:48 PM, Marc L. Allen wrote:
> Is that expected? To me, '' is different than NULL.
>
> create table a
> (
>a text
> );
>
> insert into a select '';
> select * from a;
>
> Is there a way to store an empty string?
>
works for me
punkish@mumbai ~$sqlite3
Is that expected? To me, '' is different than NULL.
create table a
(
a text
);
insert into a select '';
select * from a;
Is there a way to store an empty string?
Marc
--
**
* *
7 matches
Mail list logo
