Thanks!
Sadly the whole thing is a bit of a mess on the DBI side where old
names have changed values (like SQL_LONGVARCHAR was -1 now 12).
I think I need to 'bite the bullet' and just change/add them to
match the new standard. There may be some knock-on effects for
drivers and applications that generate/use the old values.
Do you have a reference to any docs that explain the transation
of the types and/or what the SQL_TYPE_ and SQL_CODE_ prefixes
are all about?
Tim.
On Tue, Aug 28, 2001 at 12:03:27PM +0200, Steffen Goeldner wrote:
> Steffen Goeldner wrote:
> >
> > Patch follows.
> >
>
> Steffen
> Common subdirectories: DBD-Oracle-1.08-orig/Oracle.ex and DBD-Oracle-1.08/Oracle.ex
> diff -c DBD-Oracle-1.08-orig/Oracle.pm DBD-Oracle-1.08/Oracle.pm
> *** DBD-Oracle-1.08-orig/Oracle.pm Tue Aug 07 02:25:50 2001
> --- DBD-Oracle-1.08/Oracle.pm Mon Aug 27 21:28:51 2001
> ***************
> *** 452,459 ****
> [ 'DOUBLE', 8, 15, undef, undef, undef, 1, '0', 3,
> '0', '0', '0', undef, undef, undef, 8, undef, 10
> ],
> ! [ 'DATE', 11, 19, '\'', '\'', undef, 1, '0', 3,
> ! undef, '0', '0', undef, '0', '0', 11, undef, undef
> ],
> [ 'VARCHAR2', 12, 2000, '\'', '\'', 'max length', 1, 1, 3,
> undef, '0', '0', undef, undef, undef, 12, undef, undef
> --- 452,459 ----
> [ 'DOUBLE', 8, 15, undef, undef, undef, 1, '0', 3,
> '0', '0', '0', undef, undef, undef, 8, undef, 10
> ],
> ! [ 'DATE', 93, 19, '\'', '\'', undef, 1, '0', 3,
> ! undef, '0', '0', 'DATE', '0', '0', 9, 3, undef
> ],
> [ 'VARCHAR2', 12, 2000, '\'', '\'', 'max length', 1, 1, 3,
> undef, '0', '0', undef, undef, undef, 12, undef, undef
> diff -c DBD-Oracle-1.08-orig/dbdimp.c DBD-Oracle-1.08/dbdimp.c
> *** DBD-Oracle-1.08-orig/dbdimp.c Tue Aug 07 02:25:44 2001
> --- DBD-Oracle-1.08/dbdimp.c Mon Aug 27 21:44:46 2001
> ***************
> *** 1891,1897 ****
> break;
> case SQLT_CHR: sql_fbh.dbtype = SQL_VARCHAR; break;
> case SQLT_LNG: sql_fbh.dbtype = SQL_LONGVARCHAR; break; /* long */
> ! case SQLT_DAT: sql_fbh.dbtype = SQL_DATE; break;
> case SQLT_BIN: sql_fbh.dbtype = SQL_BINARY; break; /* raw */
> case SQLT_LBI: sql_fbh.dbtype = SQL_LONGVARBINARY; break; /* long raw */
> case SQLT_AFC: sql_fbh.dbtype = SQL_CHAR; break; /* Ansi fixed char
>*/
> --- 1891,1897 ----
> break;
> case SQLT_CHR: sql_fbh.dbtype = SQL_VARCHAR; break;
> case SQLT_LNG: sql_fbh.dbtype = SQL_LONGVARCHAR; break; /* long */
> ! case SQLT_DAT: sql_fbh.dbtype = 93; break; /*
>SQL_TYPE_TIMESTAMP */
> case SQLT_BIN: sql_fbh.dbtype = SQL_BINARY; break; /* raw */
> case SQLT_LBI: sql_fbh.dbtype = SQL_LONGVARBINARY; break; /* long raw */
> case SQLT_AFC: sql_fbh.dbtype = SQL_CHAR; break; /* Ansi fixed char
>*/
> Common subdirectories: DBD-Oracle-1.08-orig/hints and DBD-Oracle-1.08/hints
> Common subdirectories: DBD-Oracle-1.08-orig/t and DBD-Oracle-1.08/t
