RE: 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
> 

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