--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

>
> > 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
>

It does work with plain text. I'm not doing anything special with character sets. Whatever the default is, is what I am using. Version is 2.1.2.