Re: Defining type_info Was: DBIstcf_DISCARD_STRING and DBIstcf_STRICT

On 06/02/13 02:48, Lyle wrote:
> 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
>

It is in the MS SQL Server driver but I've no seen it in others yet.

Martin

-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com