Re: Defining type_info Was: DBIstcf_DISCARD_STRING and DBIstcf_STRICT

On 05/02/2013 14:33, Martin J. Evans wrote:
> ODBC added a new column just recently:
>
> perl -le 'use DBI; my $h = DBI->connect; my $x =h->type_info_all; use 
> Data::Dumper; print Dumper($x)'
> $VAR1 = [
>           {
>             'UNSIGNED_ATTRIBUTE' => 9,
>             'MAXIMUM_SCALE' => 14,
>             'INTERVAL_PRECISION' => 18,
>             'CREATE_PARAMS' => 5,
>             'NUM_PREC_RADIX' => 17,
>             'SEARCHABLE' => 8,
>             'USERTYPE' => 19, <----------------- see here
>             'LOCAL_TYPE_NAME' => 12,
>             'AUTO_INCREMENT' => 11,
>             'MONEY' => 10,
>             'LITERAL_PREFIX' => 3,
>             'COLUMN_SIZE' => 2,
>             'MINIMUM_SCALE' => 13,
>             'TYPE_NAME' => 0,
>             'NULLABLE' => 6,
>             'DATA_TYPE' => 1,
>             'SQL_DATA_TYPE' => 15,
>             'CASE_SENSITIVE' => 7,
>             'LITERAL_SUFFIX' => 4,
>             'SQL_DATETIME_SUB' => 16
>           },

I just noticed that they don't mention this new column on their site:
http://msdn.microsoft.com/en-us/library/ms715410%28v=vs.85%29.aspx
http://msdn.microsoft.com/en-us/library/windows/desktop/ms714632%28v=vs.85%29.aspx


Lyle