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=ham
	autolearn_force=no version=3.4.4
X-Google-Thread: 103376,bf02c238a92156a3
X-Google-Attributes: gid103376,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: 
 g2news1.google.com!news4.google.com!news.glorb.com!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!t-online.de!news-lei1.dfn.de!news-ham1.dfn.de!news.uni-hamburg.de!cs.tu-berlin.de!uni-duisburg.de!not-for-mail
From: Georg Bauhaus <sb463ba@l1-hrz.uni-duisburg.de>
Newsgroups: comp.lang.ada
Subject: Re: Windows Ada database support.
Date: Mon, 6 Dec 2004 19:44:25 +0000 (UTC)
Organization: GMUGHDU
Message-ID: <cp2cqp$3ff$1@a1-hrz.uni-duisburg.de>
References: <5e3e03a7.0411240431.7e037a4e@posting.google.com>
 <2004112420030750073%david@bottoncom>
 <mWopd.59182$Le1.1224388@news20.bellglobal.com>
 <vftyrbanzux4$.q4cw1i7499xx$.dlg@40tude.net>
 <Lh_sd.7289$l%5.453348@news20.bellglobal.com>
 <11w2chxxtggn9.a442ecwtujd2$.dlg@40tude.net>
 <K_0td.8027$l%5.510635@news20.bellglobal.com>
NNTP-Posting-Host: l1-hrz.uni-duisburg.de
X-Trace: a1-hrz.uni-duisburg.de 1102362265 3567 134.91.1.34 (6 Dec 2004
 19:44:25 GMT)
X-Complaints-To: usenet@news.uni-duisburg.de
NNTP-Posting-Date: Mon, 6 Dec 2004 19:44:25 +0000 (UTC)
User-Agent: tin/1.5.8-20010221 ("Blue Water") (UNIX) (HP-UX/B.11.00
 (9000/800))
Xref: g2news1.google.com comp.lang.ada:6809
Date: 2004-12-06T19:44:25+00:00
List-Id: <comp.lang.ada>

Warren W. Gay VE3WWG <ve3wwg@nospam.cogeco.ca> wrote:
: Still others like MySQL use some weird idea of an auto
: increment integer field (I am too lazy to look up the
: specifics for this, but this is documented in the APQ
: manual).

In fact the MySQL auto increment ids are no more than a
convenience, you can actually overwrite the keys at will,
with interesting side effects. (A customer has asked us to
change internal auto inc keys, because they had told another
company the internal ids and had assumed auto inc ids would be
the same on different computers running different DB instances
at differnt times... At another installation site, the DB is
Oracle.  They have been warned...)


: Here's another good one: Some databases allow you to declare
: a VARCHAR(256). Others are restricted to VARCHAR(255), and you
: must switch to a different type (TEXT I think), if you need
: longer fields.

In addition, depending on database version and driver,
Oracle might give you quite a variety of types for each of
text fields, floats, and others.

 
-- Georg