Using Quoted Identifiers

When enabled, the DBQUOTEDIDENT option specifies that DB-Library will automatically place double quotation marks (") around certain object names that are called quoted identifiers. The DBQUOTEDIDENT option is disabled by default.

Call dbsetopt with the DBQUOTEDIDENT option to enable the use of quoted identifiers. Call dbclropt with the DBQUOTEDIDENT option to disable the use of quoted identifiers. Call dbisopt to check the status of the DBQUOTEDIDENT option. When you use DBQUOTEDIDENT, you must set param to NULL.

The following table lists the functions and the parameters that are affected when DBQUOTEDIDENT is enabled.

Function Parameter(s)
bcp_init tblname
dbrpcinit rpcname
dbupdatetext dest_object
src_object
dbuse dbname
dbwritetext objname

When you call dbrpcinit, you must explicitly place quotation marks around remote procedure names that require quotation marks in the rpcname parameter. This example demonstrates the use of quotation marks in rpcname.

"My server".."My RPC"