Re: column_info()'s COLUMN_DEF values - literal vs function

Tim Bunce wrote:

> I'd be interested in the COLUMN_DEF values for other databases and DBDs
> but it's not urgent. Hopefully others can fill in the gaps.
> (Oracle and mysql are two big missing databases at the moment.).

DBD::Oracle (s/current_user/user)
undef, 'TST', 'MARTIN', 'A', '3', 'NUMBER', '38', '40', '0', '10', '1', undef, 'NULL', '3', undef, undef, '1', 'YES'
undef, 'TST', 'MARTIN', 'B', '3', 'NUMBER', '38', '40', '0', '10', '1', undef, '1', '3', undef, undef, '2', 'YES'
undef, 'TST', 'MARTIN', 'C', '1', 'CHAR', '20', '20', undef, undef, '1', undef, ''fred'', '1', undef, undef, '3', 'YES'
undef, 'TST', 'MARTIN', 'D', '1', 'CHAR', '30', '30', undef, undef, '1', undef, 'user

DBD::ADO

Provider=MSDAORA (s/current_user/user)
undef, 'TST', 'MARTIN', 'A', 2, 'NUMBER', 38, undef, 0, undef, 1, undef, undef, 2, undef, undef, '1', 'YES'
undef, 'TST', 'MARTIN', 'B', 2, 'NUMBER', 38, undef, 0, undef, 1, undef, undef, 2, undef, undef, '2', 'YES'
undef, 'TST', 'MARTIN', 'C', 1, 'CHAR', 20, '20', undef, undef, 1, undef, undef, 1, undef, '20', '3', 'YES'
undef, 'TST', 'MARTIN', 'D', 1, 'CHAR', 30, '30', undef, undef, 1, undef, undef, 1, undef, '30', '4', 'YES'

Provider=SQLOLEDB
'master', 'dbo', 'martin', 'a', 4, 'int', 10, undef, undef, undef, 1, undef, 'null', 4, undef, undef, '1', 'YES'
'master', 'dbo', 'martin', 'b', 4, 'int', 10, undef, undef, undef, 1, undef, '1', 4, undef, undef, '2', 'YES'
'master', 'dbo', 'martin', 'c', 1, 'char', 20, '20', undef, undef, 1, undef, ''fred'', 1, undef, '20', '3', 'YES'
'master', 'dbo', 'martin', 'd', 1, 'char', 30, '30', undef, undef, 1, undef, 'user_name()', 1, undef, '30', '4', 'YES'

Provider=VFPOLEDB
undef, undef, 'martin', 'a', 4, 'I', 4, undef, undef, undef, 1, undef, '.NULL.', 4, undef, undef, '1', 'YES'
undef, undef, 'martin', 'b', 4, 'I', 4, undef, undef, undef, 1, undef, '1', 4, undef, undef, '2', 'YES'
undef, undef, 'martin', 'c', 1, 'C', 20, '20', undef, undef, 1, undef, '"fred"', 1, undef, '20', '3', 'YES'
undef, undef, 'martin', 'd', 1, 'C', 30, '30', undef, undef, 1, undef, 'current_user', 1, undef, '30', '4', 'YES'

Provider=Microsoft.Jet.OLEDB.4.0
undef, undef, 'martin', 'a', 4, 'Long', 10, undef, undef, undef, 1, undef, 'NULL', 4, undef, undef, '1', 'YES'
undef, undef, 'martin', 'b', 4, 'Long', 10, undef, undef, undef, 1, undef, '1', 4, undef, undef, '2', 'YES'
undef, undef, 'martin', 'c', -8, undef, '20', '40', undef, undef, 1, undef, ''fred'', -8, undef, '40', '3', 'YES'
undef, undef, 'martin', 'd', -8, undef, '30', '60', undef, undef, 1, undef, 'current_user', -8, undef, '60', '4', 'YES'


Steffen