Non-Numeric column default values are not quoted #251
Description
Hello,
we use the SQLColumnsW function to fetch metadata for tables. For tests we have a table declared like this:
create table default_values
(
d_id INTEGER NOT NULL,
d_fld1 INTEGER DEFAULT 123456,
d_fld2 FLOAT DEFAULT 123.456,
d_fld3 VARCHAR(10) DEFAULT 'xyz',
d_fld4 DATE default '2003-12-11',
d_fld5 TIME default '23:12:11',
d_fld6 TIMESTAMP default '2003-12-11 23:12:11',
primary key (d_id)
);
When fetching the columns info using SQLColumnsW, the default values of the fields d_fld3 to d_fld6 are not quoted which leads to problems in programs that need those default values.
If we do the same test using Microsoft SQL Server and its ODBC driver, the default values are returned like this:
d_fld3 -> ('xyz')
d_fld4 -> ('2003-12-11')
d_fld5 -> ('23:12:11')
d_fld6 -> ('2003-12-11 23:12:11')
Is there any chance for the driver to change its behavior?