FW: Break char (\0)

        I am using DBI v1.37 with DBD-Sybase 0.94 and freetds V0.60
I seem to be getting \0 appended to the end of the strings returned
through the DBI.
I have tried different versions of the DBD-Sybase and freetds and still
have the same problem.

Is there someway that I can get freetds to strip this char ?

Also, if I could get freetds to globally strip of other nominated chars as
well (eg \n and/or \r) as well, it would be of great assistance.
I can do this a the Perl interpreter level, but it is quite resource
expensive.
If it could be done at the machine code (driver level), it would be much
more efficient.

Thanks for any help.

Cheers
Michael Eales

-----Original Message-----
From: news [mailto:news@xxxxxxxxxxxxx]On Behalf Of Michael Peppler
Sent: Thursday, 21 August 2003 4:03 PM
To: dbi-users@xxxxxxxx
Subject: Re: Break char (\0)


On Thu, 21 Aug 2003 14:17:59 +0800, Michael Eales wrote:
>
>       I am using DBI v1.37 with DBD-Sybase 0.94 and freetds V0.60
> I seem to be getting \0 appended to the end of the strings returned
> through the DBI.
> I have tried different versions of the DBD-Sybase and freetds and still
> have the same problem.

This is a problem with FreeTDS, and has to do with NULL terminating
strings or not. I think that if you check the FreeTDS mailing list
archives you will find information about this problem.

Michael
--
Michael Peppler                              Data Migrations, Inc.
mpeppler@xxxxxxxxxxx                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html