php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #33221 sybase-ct: Varchar >255 not supported
Submitted: 2005-06-02 16:05 UTC Modified: 2016-12-30 22:48 UTC
Votes:5
Avg. Score:4.6 ± 0.8
Reproduced:5 of 5 (100.0%)
Same Version:0 (0.0%)
Same OS:2 (40.0%)
From: graham1 dot simpson at hsbcib dot com Assigned:
Status: Open Package: Sybase-ct (ctlib) related
PHP Version: 5.0.4 OS: Linux Redhat AS 3.0
Private report: No CVE-ID: None
Password:
Status:
Package:
Bug Type:
Summary:
From: graham1 dot simpson at hsbcib dot com
New email:
PHP Version: OS:

 

 [2005-06-02 16:05 UTC] graham1 dot simpson at hsbcib dot com
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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2016-12-30 22:48 UTC] cmb@php.net
-Package: Feature/Change Request +Package: Sybase-ct (ctlib) related
 
PHP Copyright © 2001-2018 The PHP Group
All rights reserved.
Last updated: Tue Jul 17 11:01:54 2018 UTC