Re: How to do this

Frank van Bortel wrote:
>> in ADO.NET comes as
>>
>> %\0O\0L\0E\0_\0S\0E\0R\0V\0E\0R\0%\0\\\0C\0r\0o\0s\0s\0S\0e\0c\0t\0i\0o\0n\0s\0\\\0C\0.\0s\0y\0m\0\0\0
>>
>>
>> When I do a DataReader.GetString(ColnName). ? Why is that ?
>>

Looks like some sort of conversion going on, and might behave differently with different providers. Is there any chance at all of not using the RAW data type, perhaps using a CLOB or BLOB datatype? These are much more amenable to manipulation, and there are good ADO.Net examples on OTN on how to work with them.

My personal take on RAW is that it is (usually) fine for images and similar, but documents (or doc scraps which looks to be what these are?) tend to work better in an appropriate LOB column.

-- 

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/