Subject RE: [firebird-support] Re: Change Blob Sub_Type
Author Alan McDonald
> I don't see why I should have to. This works with any other content in
> the Blob field with the exception of XML.
>
> Here is a snippet from the contents of the XML data in the blob field :
>
> <?xml version="1.0" encoding="UTF-16" ?>
> <dta:CSInvoice xmlns:msg="http://Epicor.com/InternalMessage/1.1"
> xmlns:dta="http://Epicor.com/SC/UserSchema">
> <dta:InvcHead>
> <dta:InvoiceNum>1239660</dta:InvoiceNum>
> <dta:CSConfirmationNum>580459</dta:CSConfirmationNum>
>
> When I search for "580459" using containing, I do not get this record
> returned, or any for that matter.
>
> If there are no other suggestions, then this sounds like a bug.

What character sets are you mixing in with all this?
try a simple test first with plain text in this field. You'll need to prove
a bug.
I've been using this with HTML for years and never experienced any misses
Alan