Steffen Goeldner wrote:
>
> Tim Bunce wrote:
> >
> > I'll happily accept a patch that adds the new standard types as well,
>
> Attached.
>
Sorry, I forgot to patch the documentation ...
Steffen
*** DBI-1.20.orig/DBI.pm Sat Aug 25 01:33:52 2001
--- DBI-1.20/DBI.pm Thu Nov 08 20:18:47 2001
***************
*** 1606,1619 ****
The following SQL standard type constants can be imported individually
or, by importing the special C<:sql_types> tag, all together:
- SQL_CHAR SQL_NUMERIC SQL_DECIMAL SQL_INTEGER SQL_SMALLINT
- SQL_FLOAT SQL_REAL SQL_DOUBLE SQL_VARCHAR
- SQL_DATE SQL_TIME SQL_TIMESTAMP
- SQL_LONGVARCHAR SQL_BINARY SQL_VARBINARY SQL_LONGVARBINARY
- SQL_BIGINT SQL_TINYINT
- SQL_WCHAR SQL_WVARCHAR SQL_WLONGVARCHAR
- SQL_BIT
SQL_ALL_TYPES
See the L</type_info>, L</type_info_all>, and L</bind_param> methods
for possible uses.
--- 1606,1671 ----
The following SQL standard type constants can be imported individually
or, by importing the special C<:sql_types> tag, all together:
SQL_ALL_TYPES
+ SQL_ARRAY
+ SQL_ARRAY_LOCATOR
+ SQL_BIGINT
+ SQL_BINARY
+ SQL_BIT_VARYING
+ SQL_BLOB
+ SQL_BLOB_LOCATOR
+ SQL_BOOLEAN
+ SQL_CHAR
+ SQL_CLOB
+ SQL_CLOB_LOCATOR
+ SQL_DATE
+ SQL_DATETIME
+ SQL_DECIMAL
+ SQL_DOUBLE
+ SQL_FLOAT
+ SQL_GUID
+ SQL_INTEGER
+ SQL_INTERVAL
+ SQL_INTERVAL_DAY
+ SQL_INTERVAL_DAY_TO_HOUR
+ SQL_INTERVAL_DAY_TO_MINUTE
+ SQL_INTERVAL_DAY_TO_SECOND
+ SQL_INTERVAL_HOUR
+ SQL_INTERVAL_HOUR_TO_MINUTE
+ SQL_INTERVAL_HOUR_TO_SECOND
+ SQL_INTERVAL_MINUTE
+ SQL_INTERVAL_MINUTE_TO_SECOND
+ SQL_INTERVAL_MONTH
+ SQL_INTERVAL_SECOND
+ SQL_INTERVAL_YEAR
+ SQL_INTERVAL_YEAR_TO_MONTH
+ SQL_LONGVARBINARY
+ SQL_LONGVARCHAR
+ SQL_NUMERIC
+ SQL_REAL
+ SQL_REF
+ SQL_ROW
+ SQL_SMALLINT
+ SQL_TIME
+ SQL_TIMESTAMP
+ SQL_TINYINT
+ SQL_TYPE_DATE
+ SQL_TYPE_TIME
+ SQL_TYPE_TIMESTAMP
+ SQL_TYPE_TIMESTAMP_WITH_TIMEZONE
+ SQL_TYPE_TIME_WITH_TIMEZONE
+ SQL_UDT
+ SQL_UDT_LOCATOR
+ SQL_UNKNOWN_TYPE
+ SQL_VARBINARY
+ SQL_VARCHAR
+ SQL_WCHAR
+ SQL_WLONGVARCHAR
+ SQL_WVARCHAR
+
+ These constants are defined by SQL/CLI, ODBC or both.
+ C<SQL_BIT> is (currently) omitted, because SQL/CLI and ODBC provide
+ conflicting codes.
See the L</type_info>, L</type_info_all>, and L</bind_param> methods
for possible uses.
