UPDATE provider SET signature = '0x47494638396151002900F70000000000800000008000808000000080800080008080808080C0C0C0FF000000FF00FFFF000000FFFF00FF00FFFFFFFFFF' where ProviderID=1
Firsth thing I would do is loose the quotes:
UPDATE provider SET signature = 0x47494638396151002900F70000000000800000008000808000000080800080008080808080C0C0C0FF000000FF00FFFF000000FFFF00FF00FFFFFFFFFF where ProviderID=1
Since this is an Image field it will take quoted data as a character string rather than a binary stream.
But when I try it, using your string in either method abovce I get what I would expect: from yours the ASCI string for '0' 'x' '4' '7' ...
Without the quotes I get the right data. Are you sure you are reading the data correctly?