Not logged in : Login

About: What Does Use SPACE For SQL_IDENTIFIER_QUOTE_CHAR Do? -- Answer     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : schema:Answer, within Data Space : associated with source document(s)
QRcode icon

  • What Does Use SPACE For SQL_IDENTIFIER_QUOTE_CHAR Do? -- Answer
  • ODBC
  • JDBC
  • UDA
  • This is a Progress SQL-89 specific option which if set the driver returns " " rather than "" to represent this database does not have a quoted identifier character. The ODBC specification says that " " is what should be returned but some applications (like Crystal Reports) interpret this response as meaning the quoted identifier character is a "space", which obviously does not make sense and fails, as they are expecting "" to be returned hence this need for this option.
is acceptedAnswer of
Faceted Search & Find service v1.17_git115 as of Sep 09 2022

Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3322 as of Apr 19 2022, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory, 23 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2022 OpenLink Software