You posted this exact same issue here: Weird insert error
The error can be reproduced by casting the string to tinyint (INT1). Somewhere there is an attempt to convert the value - and as was stated before, it has to be somewhere in the code or definition of the table. It would help if you posted the full definition of the table - including any computed columns and triggers.