|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2016-12-30 22:48 UTC] cmb@php.net
-Package: Feature/Change Request
+Package: Sybase-ct (ctlib) related
[2021-08-03 15:43 UTC] cmb@php.net
-Status: Open
+Status: Closed
-Assigned To:
+Assigned To: cmb
[2021-08-03 15:43 UTC] cmb@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Fri Apr 19 17:01:30 2024 UTC |
Description: ------------ PHP client application truncates text/varchar columns to 255 chars, even when compiled with a new Sybase CT open client. - I think this is more of a feature enhancement request rather than a bug per se. - Load the form mentioned belowin your web browser and add data until bigger than 255. My environment is php 5.0.4 under apache 2.0.48 with --with-sybase-ct option compiled in. The version of open client is 12.5.1. which supports large varchars. Reproduce code: --------------- To reproduce: % cat <<EOT >testform.php <html> <head> <title>testform </title> </head> <body> <?php require_once ("dbconfig.php"); if ($_POST[Submit]) { $servercomments = $_POST[servercomments]; $qry = "update tempdb..gsi set Key1 = '" . $servercomments . "'"; $result = sybase_query($qry,$cnn); } $qry = "select Key1 from tempdb..gsi"; $result = sybase_query($qry,$cnn); $row = sybase_fetch_array($result); $servercomments = $row[Key1]; echo "<form action=\"ta.php\" method=\"post\">"; echo "<textarea rows=20 cols=80 name=servercomments>"; echo "$servercomments\n"; echo "</textarea>"; echo "<input type=\"submit\" name=\"Submit\" value=\"Do It\">"; echo "</form>"; ?> </body> </html> EOT In isql: use tempdb go create table gsi (Key1 varchar(1500)) go insert gsi values ("somevalue") go Expected result: ---------------- Ideally, I would expect to get my row returned when bigger than 255 characters. Actual result: -------------- As the PHP client cannot handle varchars > 255, a server error is generated informing that a truncation has occurred: Warning: sybase_query() [function.sybase-query]: Sybase: Server message: 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. (severity 10, procedure N/A) in /home/sybase/public_html/testform.php on line 20