freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: RE: [freetds] FW: Break char (\0)
- Date: Mon, 25 Aug 2003 13:48:34 +0200
>
> 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
>
Hi!
Perhaps problem reside in tables... \0, \n and \r are correct characters
in sql server.
You can use query like
UPDATE table_name SET field_name = REPLACE(field_name, CHAR(0), '')
to remove all \0 from db.
freddy77
-
[freetds] FW: Break char (\0),
Michael Eales, 08/24/2003
- [freetds] Unable to execute two queries in a single class, mani anand, 08/25/2003
- <Possible follow-up(s)>
- RE: [freetds] FW: Break char (\0), ZIGLIO Frediano, 08/25/2003
Archive powered by MHonArc 2.6.24.