15.15 Common SQL changes

All Manuals > LispWorks Release Notes and Installation Guide > 15 Release Notes

15.15 Common SQL changes

15.15.1 Common SQL support for SQLite

Common SQL now supports SQLite databases.

15.15.2 Using non-ASCII strings on Microsoft SQL Server

Common SQL can now correctly represent all characters when passing a SQL expression containing string literals to Microsoft SQL Server via ODBC. See "Using non-ASCII strings on Microsoft SQL Server" in the LispWorks User Guide and Reference Manual .

15.15.3 Added support for fetching Oracle LOBs directly

The :binary type can be used to fetch Oracle LOBs directly in Common SQL. See "Fetching the contents of the LOBs directly" in the LispWorks User Guide and Reference Manual .

15.15.4 varbinary(max)

Fetching data from a column with type varbinary(max) now works on Microsoft SQL Server.

LispWorks Release Notes and Installation Guide - 19 Oct 2017