"Registry of values" for ANSI X3.135 and ISO/IEC 9075 SQL Standards
- From: Tim.Bunce@xxxxxxxxx (Tim Bunce)
- Date: Mon, 23 Apr 2007 22:37:20 +0100
I wonder if someone can help me with this...
In the DBI docs it refers to the range of values that are officially
registered for use by the Perl DBI in the International Standards:
=item C<TYPE> (array-ref, read-only)
Returns a reference to an array of integer values for each
column. The value indicates the data type of the corresponding column.
The values correspond to the international standards (ANSI X3.135
and ISO/IEC 9075) which, in general terms, means ODBC. Driver-specific
types that don't exactly match standard types should generally return
the same values as an ODBC driver supplied by the makers of the
database. That might include private type numbers in ranges the vendor
has officially registered with the ISO working group:
ftp://sqlstandards.org/SC32/SQL_Registry/
Where there's no vendor-supplied ODBC driver to be compatible with,
the DBI driver can use type numbers in the range that is now
officially reserved for use by the DBI: -9999 to -9000.
All possible values for C<TYPE> should have at least one entry in the
output of the C<type_info_all> method (see L</type_info_all>).
=cut
The sqlstandards.org ftp server isn't accepting anonymous ftp access
any more and I'd like to get a copy of the current registry.
Doesn't anyone know where I could get a copy?
Or alternatively, could someone send me Jim Melton's current email address?
(He was the maintainer of the Registry back in 1998. He worked at
Sybase at the time and later at Oracle.)
Tim.
.
- Follow-Ups:
- Prev by Date: Re: DBI pure perl version 1.54
- Next by Date: Re: "Registry of values" for ANSI X3.135 and ISO/IEC 9075 SQL Standards
- Previous by thread: Re: DBI pure perl version 1.54
- Next by thread: Re: "Registry of values" for ANSI X3.135 and ISO/IEC 9075 SQL Standards
- Index(es):
Relevant Pages
|
|
