Documentation Source Text: Check-in [b1b9dd90bb]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview

Comment:	Another accidental fork merge.
Timelines:	family \| ancestors \| descendants \| both \| trunk
Files:	files \| file ages \| folders
SHA1:	b1b9dd90bb0f2b8a958920e23953285c6d30d52a
User & Date:	drh 2014-05-25 20:11:37

Context

2014-05-25
21:54		Add instructions for how to do arbitrary schema changes to the ALTER TABLE documentation. check-in: 227fb14d50 user: drh tags: trunk
20:11		Another accidental fork merge. check-in: b1b9dd90bb user: drh tags: trunk
20:08		Enhancements to the optoverview.html document: Added discussion of partial sorting and fixed the conditions for query flattening. check-in: fc0e9baa66 user: drh tags: trunk
2014-05-24
17:31		Merge accidental fork check-in: 0f2064446a user: drh tags: trunk

Changes

Hide Diffs Unified Diffs Show Whitespace Changes Patch

Changes to pages/faq.in.


faq {
  How do I use a string literal that contains an embedded single-quote (')
  character?
} {
  <p>The SQL standard specifies that single-quotes in strings are escaped
  by putting two single quotes in a row.  SQL works like the Pascal programming
  language in the regard.  SQLite follows this standard.  Example:
  </p>

  <blockquote><pre>
    INSERT INTO xyz VALUES('5 O''clock');
  </pre></blockquote>
}


faq {
  How do I use a string literal that contains an embedded single-quote (')
  character?
} {
  <p>The SQL standard specifies that single-quotes in strings are escaped
  by putting two single quotes in a row.  SQL works like the Pascal programming
  language in this regard. Example:
  </p>

  <blockquote><pre>
    INSERT INTO xyz VALUES('5 O''clock');
  </pre></blockquote>
}