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

>
> >
> > Thank you both for your help.
> >
> > Do you think this would work if I saved the contents of this field to
> > disk for each record, recreated the blob as text type, and then loaded
> > the blob field with the files from disk?
> >
> > Would this give me a different result than creating a new field and
> > moving the data (update table set newfield = oldfield)?
> >
>
> clarify the content for us.
> Is there UTF-16 characters in this content?
> or is the xml header something you have copied from somewhere and it's just
> for transport?
> Can you send me one entire field content?
> Alan
>

The entire contents of the XML are exactly as follows:

<?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>1247960</dta:InvoiceNum>
<dta:CSConfirmationNum>631999</dta:CSConfirmationNum>
<dta:StrongOrderNum>9872</dta:StrongOrderNum>
<dta:AMCPONum>CS114832</dta:AMCPONum>
<dta:OrderNum>284591</dta:OrderNum>
<dta:InvoiceTypeDesc>Shipment</dta:InvoiceTypeDesc>
<dta:CreditMemo>false</dta:CreditMemo>
<dta:DebitNote>false</dta:DebitNote>
<dta:InvoiceDate>2009-04-16T00:00:00-05:00</dta:InvoiceDate>
<dta:ShipDate>2009-04-16T00:00:00-05:00</dta:ShipDate>
<dta:DueDate>2009-04-16T00:00:00-05:00</dta:DueDate>
<dta:DspSubTotal>698</dta:DspSubTotal>
<dta:TaxAmt>57.59</dta:TaxAmt>
<dta:InvoiceAmt>755.59</dta:InvoiceAmt>
<dta:MiscChargeTotal>NaN</dta:MiscChargeTotal>
<dta:FreightCharge>NaN</dta:FreightCharge>
<dta:FreightTaxed>false</dta:FreightTaxed>
<dta:CustomerName>AMC/LOEWS - WEB PURCHASE</dta:CustomerName>
<dta:FOBDescription>BALDWIN PARK</dta:FOBDescription>
<dta:TermsCodeDescription>CHARGE CARD</dta:TermsCodeDescription>
<dta:InvoiceComment>.LTI PO#: 71024

4/13/09 1Z07AR010310803953</dta:InvoiceComment>
<dta:ShipToNum>AMC0239</dta:ShipToNum>
<dta:ShipToNumName>Covina 30</dta:ShipToNumName>
<dta:ShipViaCodeDescription>UPS GROUND</dta:ShipViaCodeDescription>
<dta:PackNum>209431</dta:PackNum>
</dta:InvcHead>
<dta:InvcLine>
<dta:InvoiceLine>1</dta:InvoiceLine>
<dta:RevisionNum></dta:RevisionNum>
<dta:POLine></dta:POLine>
<dta:UnitPrice>698</dta:UnitPrice>
<dta:ExtPrice>698</dta:ExtPrice>
<dta:DiscountPercent>0</dta:DiscountPercent>
<dta:Discount>0</dta:Discount>
<dta:OrdBasedPrice>698</dta:OrdBasedPrice>
<dta:TotalMiscChrg>0</dta:TotalMiscChrg>
<dta:DspLineTax>57.59</dta:DspLineTax>
<dta:DspLineTotal>755.59</dta:DspLineTotal>
<dta:SellingShipQty>1</dta:SellingShipQty>
<dta:OrderUM>EA</dta:OrderUM>
<dta:PartNumTrackSerialNum>true</dta:PartNumTrackSerialNum>
</dta:InvcLine>
<dta:InvcMiscCharge>
<dta:InvoiceLine>1</dta:InvoiceLine>
<dta:MiscCodeDesc>FREIGHT ABSORB</dta:MiscCodeDesc>
<dta:MiscAmt>0</dta:MiscAmt>
</dta:InvcMiscCharge>
<dta:TaxDtl>
<dta:InvcTax>
<dta:ReportableAmt>698</dta:ReportableAmt>
<dta:TaxableAmt>698</dta:TaxableAmt>
<dta:Percent>6.25</dta:Percent>
<dta:TaxAmt>43.63</dta:TaxAmt>
<dta:TaxDescription>CA STATE TAX</dta:TaxDescription>
</dta:InvcTax>
<dta:InvcTax>
<dta:ReportableAmt>698</dta:ReportableAmt>
<dta:TaxableAmt>698</dta:TaxableAmt>
<dta:Percent>2</dta:Percent>
<dta:TaxAmt>13.96</dta:TaxAmt>
<dta:TaxDescription>CA LOS ANGELES COUNTY</dta:TaxDescription>
</dta:InvcTax>
<dta:LineTax>
<dta:InvoiceLine>1</dta:InvoiceLine>
<dta:ReportableAmt>698</dta:ReportableAmt>
<dta:TaxableAmt>698</dta:TaxableAmt>
<dta:Percent>6.25</dta:Percent>
<dta:TaxAmt>43.63</dta:TaxAmt>
<dta:TaxDescription>CA STATE TAX</dta:TaxDescription>
</dta:LineTax>
<dta:LineTax>
<dta:InvoiceLine>1</dta:InvoiceLine>
<dta:ReportableAmt>698</dta:ReportableAmt>
<dta:TaxableAmt>698</dta:TaxableAmt>
<dta:Percent>2</dta:Percent>
<dta:TaxAmt>13.96</dta:TaxAmt>
<dta:TaxDescription>CA LOS ANGELES COUNTY</dta:TaxDescription>
</dta:LineTax>
</dta:TaxDtl>
</dta:CSInvoice>