Skip to content

Non-Numeric column default values are not quoted #251

@marsupilami79

Description

@marsupilami79

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions