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

[Lester C. <le...@ls...>]

Jim Starkey wrote:

>> <SL> The JDBC conventions are more than appropriate for Java and (as 
>> you suggest) internal uses, there are plenty of languages where a 
>> NUMERIC( 10, 2) and NUMERIC( 15, 2) would have significantly different 
>> meanings, due to the data access components.  Therefore, the load/dump 
>> utility could produce a database which is incompatible with the target 
>> application.
>>
> OK, I've got a problem to solve.  Anybody: How do I tell from the 
> Firebird system tables the difference between numeric(10,2) and 
> decimal(10,2)?  Anybody?  Anybody?

OK does it matter, but any chance we could follow
http://www.w3.org/TR/xmlschema-2/
when doing this

I know it is a bit heavy, but if everything is already in XML datatype 
format we are getting ahead of the game - even if we only keep to the 
same 'element' names at this stage. It does handle base64Binary amongst 
other things.

For example
CHAR = string with
<length value='8' fixed='true'/>
<whiteSpace value='preserve'/>

VARCHAR = string with
<length value='8' fixed='false'/>
<whiteSpace value='collapse'/>

At the very least can we avoid anything that precludes a switch to the 
standard at some point?

-- 
Lester Caine
-----------------------------
L.S.Caine Electronic Services