From ba073cf7848891484c0ba3b0c450ec860fbc6757 Mon Sep 17 00:00:00 2001 From: Russ Tyndall Date: Tue, 18 Oct 2011 17:21:49 -0400 Subject: [PATCH] added nvarchar to the possible sql-to-c-types for ODBC backend --- ChangeLog | 5 +++++ db-odbc/odbc-api.lisp | 3 ++- 2 files changed, 7 insertions(+), 1 deletion(-) diff --git a/ChangeLog b/ChangeLog index ae9680c..005158f 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,3 +1,8 @@ +2011-10-18 Russ Tyndall + * db-odbc/odbc-api.lisp + + Added type specifier so MSSQL nvarchar fields can make it through + 2011-09-12 Russ Tyndall * sql/fddl.lisp sql/generic-postgres.lisp db-mysql/mysql-sql.lisp sql/generic-odbc.lisp sql/odbc-api.lisp sql/odbc-dbi.lisp diff --git a/db-odbc/odbc-api.lisp b/db-odbc/odbc-api.lisp index af36bb9..8541145 100644 --- a/db-odbc/odbc-api.lisp +++ b/db-odbc/odbc-api.lisp @@ -586,8 +586,9 @@ as possible second argument) to the desired representation of date/time/timestam (defun sql-to-c-type (sql-type) (ecase sql-type + ;; Added -10 for MSSQL ntext type and -11 for nvarchar ((#.$SQL_CHAR #.$SQL_VARCHAR #.$SQL_LONGVARCHAR - #.$SQL_NUMERIC #.$SQL_DECIMAL -8 -9 -10) $SQL_C_CHAR) ;; Added -10 for MSSQL ntext type + #.$SQL_NUMERIC #.$sql_decimal -8 -9 -10 -11) $SQL_C_CHAR) (#.$SQL_INTEGER $SQL_C_SLONG) (#.$SQL_BIGINT $SQL_C_SBIGINT) (#.$SQL_SMALLINT $SQL_C_SSHORT) -- 2.34.1