[phpesp-dev] mssql support

[Joel P. (Volt) <a-j...@mi...>]

I'm looking into helping the project's mssql (sql server) support and found that the adodb data dictionary doesn't quote reserved words. What's the chances of changing a field name for better database compatibility?

CREATE TABLE phpesp_question (
id                       INT IDENTITY(1,1) NOT NULL,
survey_id                INT NOT NULL,
name                     VARCHAR(30) NOT NULL,
type_id                  INT NOT NULL,
result_id                INT NULL,
length                   INT DEFAULT 0 NOT NULL,
precise                  INT DEFAULT 0 NOT NULL,
position                 INT NOT NULL,
content                  TEXT NULL,
required                 VARCHAR(1) DEFAULT 'N' NOT NULL,
deleted                  VARCHAR(1) DEFAULT 'N' NOT NULL,
public                   VARCHAR(1) DEFAULT 'Y' NOT NULL,
ans_uniq                 VARCHAR(1) DEFAULT 'N' NOT NULL,
                 PRIMARY KEY (id)
)


SQLState: 42000 Error Code: 156 Message: [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near the keyword 'public'.


Joel Penner
Volt
Microsoft Open Source Software Lab<http://port25.technet.com/>