I just put you xml snippet into a blob on version 2.1.2
then I did a
select field from table where field containing '580459'
and it returned the record
Alan

> -----Original Message-----
> From: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] On Behalf Of slalom91
> Sent: Friday, 8 May 2009 10:26 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Change Blob Sub_Type
>
> --- 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.
>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>