[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:

we connect using this method:

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