Re: [Firebird-devel] XML Load/Dump Utility

[Martijn T. <m.t...@up...>]

Jim et all,

How will binary blobs be handled?

This goes for plain SQL as well -=20

We now can insert text-blobs via a simple (non-parameterized) SQL
statement, but we cannot insert/update binary blobs yet.

Other database systems can, for example, MS SQL Server:

INSERT INTO ...
VALUES (0x0011A301EF01 ... etc)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS =
SQL Server.
Upscene Productions
http://www.upscene.com


  My evolving XML schema looks like this:

<?xml version=3D"1.0" encoding=3D"US-ASCII"?>
<database>
   <metadata>
      <table name=3D"MESSAGES">
         <column name=3D"TRANS_NOTES" type=3D"blob"/>
         <column name=3D"EXPLANATION" type=3D"blob"/>
         <column name=3D"ACTION" type=3D"blob"/>
         <column name=3D"TEXT" type=3D"varchar" precision=3D"118"/>
         <column name=3D"CODE" type=3D"int"/>
         <column name=3D"FLAGS" type=3D"smallint"/>
         <column name=3D"NUMBER" type=3D"smallint"/>
         <column name=3D"FAC_CODE" type=3D"smallint"/>
         <column name=3D"SYMBOL" type=3D"varchar" precision=3D"32"/>
         <column name=3D"ROUTINE" type=3D"varchar" precision=3D"32"/>
         <column name=3D"MODULE" type=3D"varchar" precision=3D"32"/>
      </table>
   </metadata>
   <data>
      <rows table=3D"MESSAGES">
         <row TEXT=3D"Do you want to roll back your updates?" =
CODE=3D"10351" NUMBER=3D"351" FAC_CODE=3D"1" SYMBOL=3D"" =
ROUTINE=3D"process_statement"/>
         <row TEXT=3D"gen_descriptor: dtype not recognized" =
CODE=3D"10352" NUMBER=3D"352" FAC_CODE=3D"1" =
ROUTINE=3D"gen_descriptor"/>
         <row TEXT=3D"MOVQ_move: conversion not done" CODE=3D"10047" =
NUMBER=3D"47" FAC_CODE=3D"1"/>
         <row TEXT=3D"BLOB conversion is not supported" CODE=3D"10048" =
NUMBER=3D"48" FAC_CODE=3D"1" SYMBOL=3D"" ROUTINE=3D""/>
         <row TEXT=3D"expected type" CODE=3D"10000" NUMBER=3D"0" =
FAC_CODE=3D"1"/>
      </rows>
   </data>
</database>