Re: Windows Ada database support.

[Georg Bauhaus <sb463ba@l1-hrz.uni-duisburg.de>]

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