FreeTDS Development Group

[James Chang <james.technew AT gmail.com>]

Dear Sir,

    I'm running almost 300 boxes of FreeBSD with PHP 5.2.9 as my Web
Application front-end.

    Because my backend DB Server is Sybase ASE 15.0.2, I need to re-build my
php5-sybase_ct-5.2.9 with FreeTDS 0.82(or above). Or I will encounter 
truncated
problem when column type is Char(n), VarChar(n), Binary(n), and VarBinary(n)
datatypes where n is more than 255 bytes.

    Could you please do me a favor ?

Best Regards!

P.S.
1.The following is compiling Error message :<
/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/php_sybase_ct.c:809:
warning: cast from pointer to integer of different size
/bin/sh 
/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/libtool
--mode=link cc -DPHP_ATOM_INC
-I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/include
-I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/main
-I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct
-I/usr/local/include/php -I/usr/local/include/php/main
-I/usr/local/include/php/TSRM -I/usr/local/include/php/Zend
-I/usr/local/include/php/ext -I/usr/local/include/php/ext/date/lib
-I/usr/local/include  -I/usr/local/include/php -DHAVE_CONFIG_H  -O3
-fno-strict-aliasing -pipe -march=opteron   -o ./sybase_ct.la
-export-dynamic -avoid-version -prefer-pic -module -rpath
/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/modules
 php_sybase_ct.lo -lsybtcl -lintl -lcomn -lct -lcs -R/usr/local/lib
-L/usr/local/lib
cc -shared  .libs/php_sybase_ct.o  -Wl,--rpath -Wl,/usr/local/lib
-Wl,--rpath -Wl,/usr/local/lib -lsybtcl /usr/local/lib/libintl.so
-L/usr/local/lib -lcomn /usr/local/lib/libct.so -L/usr/lib -lcs
-march=opteron -Wl,-soname -Wl,sybase_ct.so -o ./.libs/sybase_ct.so
/usr/bin/ld: cannot find -lsybtcl
*** Error code 1

Stop in /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct.


2.The following are the FreeTDS log:
==================================================================
15:51:06.317420 48508 (net.c:542):Received packet
0000 25 00 00 01 0a 05 30 31-30 30 34 00 01 00 b7 00 |%.....01 004.....|
0010 43 68 61 72 61 63 74 65-72 20 6f 72 20 62 69 6e |Characte r or bin|
0020 61 72 79 20 64 61 74 61-20 72 65 74 75 72 6e 65 |ary data  returne|
0030 64 20 66 72 6f 6d 20 41-64 61 70 74 69 76 65 20 |d from A daptive |
0040 53 65 72 76 65 72 20 68-61 73 20 62 65 65 6e 20 |Server h as been |
0050 74 72 75 6e 63 61 74 65-64 2e 20 54 68 65 20 63 |truncate d. The c|
0060 6c 69 65 6e 74 20 61 70-70 6c 69 63 61 74 69 6f |lient ap plicatio|
0070 6e 20 64 6f 65 73 20 6e-6f 74 20 73 75 70 70 6f |n does n ot suppo|
0080 72 74 20 6d 6f 72 65 20-74 68 61 6e 20 32 35 35 |rt more  than 255|
0090 20 62 79 74 65 73 20 6f-66 20 64 61 74 61 20 61 | bytes o f data a|
00a0 73 20 61 20 72 65 73 75-6c 74 20 63 6f 6c 75 6d |s a resu lt colum|
00b0 6e 20 6f 72 20 6f 75 74-70 75 74 20 70 61 72 61 |n or out put para|
00c0 6d 65 74 65 72 2e 0a 06-64 6f 72 6f 72 6f 00 01 |meter... dororo..|
00d0 00 fd 10 00 02 00 01 00-00 00                   |........ ..|
==================================================================
i.e. Sybase ASE 15.0.2 response:"Character or binary data returned
from Adaptive Server has been truncated. The client application does
not support more than 255 bytes of data as a result column or output
parameter."