Skip to Content.
Sympa Menu

freetds - RE: [freetds] FW: Break char (\0)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page