[php-maint] Bug#769127: php5-odbc: last digit missing and being replaced by something that looked like 2 Zerobytes
kurt kuene
kuene at gmx.de
Tue Nov 11 15:33:19 UTC 2014
Package: php5-odbc
Version: 5.4.34-0+deb7u1
Severity: critical
Justification: causes serious data loss
Dear Maintainer,
we used it to connect to a sql server 2012
/etc/freetds/freetds.conf: unmodified
we used the following dsn to connect:
"DRIVER=TDS;TEXTSIZE=4096000;DATABASE=example;SERVER=db.example.com;PORT=1234"
we connect using this method:
odbc_pconnect()
we sent the following sql statements to configure our db link:
set dateformat ymd;
set textsize 4096000;
set concat_null_yields_null on;
set ansi_nulls on;
set ansi_null_dflt_on on;
set ansi_padding on;
set implicit_transactions off;
set quoted_identifier on
we encountered strange results when querying a db view:
Q1 (query 1): "select * from example_view"
Q2 (query 2): "select id from example_view"
the view "example_view" contains an INT field named "id".
the result of Q1:
the ID field was returned with the last digit missing and being replaced by something that looked like 2 Zerobytes \0\0
the result of Q2:
the ID field was returned correctly.
-- System Information:
Debian Release: 7.7
APT prefers stable
APT policy: (900, 'stable'), (700, 'oldstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-26-pve (SMP w/24 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages php5-odbc depends on:
ii dpkg 1.16.15
ii libapache2-mod-php5 [phpapi-20100525+lfs] 5.4.34-0+deb7u1
ii libc6 2.13-38+deb7u6
ii libodbc1 2.2.14p2-5
ii php5-cli [phpapi-20100525+lfs] 5.4.34-0+deb7u1
ii php5-common 5.4.34-0+deb7u1
ii ucf 3.0025+nmu3
ii unixodbc 2.2.14p2-5
php5-odbc recommends no packages.
php5-odbc suggests no packages.
-- no debconf information
More information about the pkg-php-maint
mailing list