From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00
	autolearn=unavailable autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!mx02.eternal-september.org!feeder.eternal-september.org!aioe.org!.POSTED!not-for-mail
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Newsgroups: comp.lang.ada
Subject: Re: Ada package registry?
Date: Sun, 7 Feb 2016 11:13:04 +0100
Organization: Aioe.org NNTP Server
Message-ID: <n975bf$15j4$1@gioia.aioe.org>
References: <02241ec4-0f95-4f63-9abc-092f167eb59e@googlegroups.com>
 <56af17b7$0$301$14726298@news.sunsite.dk> <n8n8ib$sqr$1@dont-email.me>
 <56b06eb8$0$301$14726298@news.sunsite.dk> <n8rcp6$f93$1@loke.gir.dk>
 <1454483747.2785.135.camel@obry.net> <n8ttvb$se2$1@loke.gir.dk>
 <n8vvfk$ml3$1@dont-email.me> <n90022$tgm$1@gioia.aioe.org>
 <n901l6$b7$1@dont-email.me> <n90fcu$rnk$1@loke.gir.dk>
 <n925rt$th2$1@dont-email.me> <n9280s$9es$1@gioia.aioe.org>
 <n92gda$725$1@dont-email.me> <n92jjv$uqo$1@gioia.aioe.org>
 <n92nnd$525$1@dont-email.me> <n92qnr$1b8c$1@gioia.aioe.org>
 <n9738g$1u1$1@dont-email.me>
NNTP-Posting-Host: LNA1TkTuMxfwTHzeJdi6nA.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.5.1
X-Notice: Filtered by postfilter v. 0.8.2
Xref: news.eternal-september.org comp.lang.ada:29398
Date: 2016-02-07T11:13:04+01:00
List-Id: <comp.lang.ada>

On 2016-02-07 10:40, Georg Bauhaus wrote:
> On 05.02.16 19:47, Dmitry A. Kazakov wrote:
>
>>> How would this be "not working"?
>>
>> type Timestamp is new Time;
>> pragma Convention (MySQL, Timestamp); -- Is it TIMESTAMP or YEAR?
>
> A SQL TIMESTAMP has enough description for it to be abstracted,
> for interfacing. By comparison, consider
>
>     type Bits is mod System.Word_Size;
>     type Pos is new Integer range 1 .. Integer'Last;
>
> Again, "not working"? Or perfectly normal?
>
>> type Decimal is delta 0.01 digits 10;
>> pragma Convention (MySQL, Decimal); -- DECIMAL (10, 2)?
>
> If C programmers get along with representing decimals in ad-hoc
> fashion, I don't see why Ada programmers should not store decimals of
> ready make types in databases, even when the RDBMS library requires
> some shielding, such as an instance of Unchecked_Conversion,
> or tackling the legacy of MySQL.

C API convert types: C type <-> ODBC type <-> SQL type <-> DB type.

Interfaces.X in Ada do not convert anything, it provides Ada types 
exactly matching their alien language counterparts.

This is the "not working" part.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de