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