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
