Groups | Search | Server Info | Login | Register

Groups > comp.lang.tcl > #55600

sqlite3 blob wrong

From rene <user4652@newsgrouper.org.invalid>
Newsgroups comp.lang.tcl
Subject sqlite3 blob wrong
Date 2026-03-20 13:06 +0000
Message-ID <1774012017-4652@newsgrouper.org> (permalink)

Show all headers | View raw

Hello

I'm using sqlite3.51.0 under windows.

I read a png-file in binary mode and get:

set c1
‰PNG

...

After write and read with database:

$d eval {create table t1(i integer, c BLOB);}
$d eval {insert into t1(1,$c1)}
set c2 [$d eval {select c from t1 where i=1}]

I get the following:

set c2
PNG\r\n\n

How could this happen? 

Regards
Rene

Back to comp.lang.tcl | Previous | Next — Next in thread | Find similar

Thread

sqlite3 blob wrong rene <user4652@newsgrouper.org.invalid> - 2026-03-20 13:06 +0000
  Re: sqlite3 blob wrong Rich <rich@example.invalid> - 2026-03-20 14:21 +0000
    Re: sqlite3 blob wrong rene <user4652@newsgrouper.org.invalid> - 2026-03-23 07:28 +0000
      Re: sqlite3 blob wrong Ralf Fassel <ralfixx@gmx.de> - 2026-03-23 09:53 +0100
        Re: sqlite3 blob wrong rene <user4652@newsgrouper.org.invalid> - 2026-03-23 11:19 +0000
          Re: sqlite3 blob wrong Ralf Fassel <ralfixx@gmx.de> - 2026-03-23 16:06 +0100
            Re: sqlite3 blob wrong Rich <rich@example.invalid> - 2026-03-23 16:23 +0000
              Re: sqlite3 blob wrong Ralf Fassel <ralfixx@gmx.de> - 2026-03-23 19:32 +0100
      Re: sqlite3 blob wrong undroidwish <undroidwish@googlemail.com> - 2026-03-23 12:27 +0100
        Re: sqlite3 blob wrong rene <user4652@newsgrouper.org.invalid> - 2026-03-23 12:42 +0000

csiph-web