How to filter invaild XML char?

Jul 1, 2008 at 10:17 PM
When i recieved data from sql, always get some char like


And using when i open the excel file create by ExcelPackage
It's shows error "Replaced Part: /xl/worksheets/sheet1.xml part with XML error.  Illegal xml character. Line 92954, column 25."
and i check the char is 
Jul 1, 2008 at 10:32 PM


szmulder wrote:
When i recieved data from sql, always get some char like


And using when i open the excel file create by ExcelPackage
It's shows error "Replaced Part: /xl/worksheets/sheet1.xml part with XML error.  Illegal xml character. Line 92954, column 25."
and i check the char is 

 is a vertical tab control character...I wonder how that is getting into your SQL Database in the first place.