Bug#231277: marked as done (quote binary data)

[Debian Bug Tracking System]

Your message dated Mon, 11 Feb 2008 16:31:26 -0200
with message-id <[EMAIL PROTECTED]>
and subject line closing old bug
has caused the Debian Bug report #231277,
regarding quote binary data
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [EMAIL PROTECTED]
immediately.)


-- 
231277: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=231277
Debian Bug Tracking System
Contact [EMAIL PROTECTED] with problems

--- Begin Message ---

Package: libdbi-perl
Version: 1.21-2
Severity: wishlist

Hi,

   I use libdbi-perl in one application that must handle binary data.

   I'd like $dbh->quote to be able to quote binary data.

   In Postgres, these values must be quoted:

     backslash                       ->    \\134
     single quote                    ->    \\047
     ascii 0 to 31 and 127 to 255    ->    \\octalvalue

   Thanks,
     Pedro

-- System Information:
Debian Release: testing/unstable
Architecture: i386
Kernel: Linux mantis 2.4.18-686 #1 Sun Apr 14 11:32:47 EST 2002 i686
Locale: LANG=pt_BR, LC_CTYPE=pt_BR (ignored: LC_ALL set to pt_BR)

Versions of packages libdbi-perl depends on:
ii  libc6                       2.3.2.ds1-10 GNU C Library: Shared libraries an
ii  perl                        5.6.1-8.2    Larry Wall's Practical Extraction 
ii  perl-base [perlapi-5.6.1]   5.6.1-8.2    The Pathologically Eclectic Rubbis

-- no debconf information

--- End Message ---

--- Begin Message ---

Hi,

I'm sorry to be the first to answer this bug in four years... I was
doing some bug triaging and found it.

>From what I could test, this bug doesn't exist any more. I cannot say
if it was present back in 2004, but today I've tried SQLite, MySQl and
Postgres (thanks Gunnar and Marga) and they were able to correctly
quote the complete Unicode range, except the ASCII 0 (NUL) character
(MySQL even did that too).

The script used for testing is this (changing the connection string):

#!/usr/bin/perl

use DBI;
use encoding utf8, STDOUT => "utf8";

$db = DBI->connect("dbi:SQLite:dbname=dbfile","","");
$a = "";
foreach(1..0x10ffff) {
        $a .= chr($_);
        if($_ % 32 == 31) {
                $d = $db->quote($a);
                $r = ($db->selectrow_array("select $d"))[0];
                die(sprintf("%6x: %s %s\n", $_-31, $a, $r)) if($r ne $a);
                $a="";
        }
}

So, if you can still reproduce this, please send the output of that
string and reopen the bug.




-- 
Martín Ferrari

--- End Message ---