Prev: Cannot find mysqlnd.dll in Windows distribution
Next: Compile php5-sybase_ct-5.2.9 with freetds-devel-0.82.1_1,1in FreeBSD ports will Failed!
From: James Chang on 26 Mar 2009 05:16 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." |