FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Actually that is not a FreeTDS error that message comes straight from the 
server, I believe the funciton you are looking for is 'substring' not 
'substr', but again the better solution is to use 'set textsize'

Brian

On Fri, 19 Apr 2002, Casey Allen Shobe wrote:

> On Friday 19 April 2002 18:32, Casey Allen Shobe wrote:
> > I'm don't know where to go from here.  Here's what the column properties
> > are: Data Type: text
> > Length: 2147483647
> > Precision: 2147483647
> > Is nullable: Yes
> 
> I thought that this may be worked around with substr, so I tried:
> $test = sybase_query ('select substr(alert_text,4000,0) from alert', 
> $piv_conn);
> 
> Unfortunately, FreeTDS doesn't appear to accept that:
> 
> Warning: Sybase: Server message: 'substr' is not a recognized function 
> name. 
> (severity 15, procedure N/A) in /www/htdocs/beta/cshobe/mssqltest.php on 
> line 
> 31
> 
>