Documentation Source Text

Check-in [0b81bc6851]
Login

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

Overview
Comment:Add documentation for the unicode() and char() functions.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 0b81bc6851d4aaad721936199ef26f8bb03f3a7c
User & Date: drh 2013-02-25 14:52:04
Context
2013-02-25
15:48
Record the incremental vacuum enhancements in the change-log for 3.7.16. check-in: 638d9567ad user: drh tags: trunk
14:52
Add documentation for the unicode() and char() functions. check-in: 0b81bc6851 user: drh tags: trunk
2013-02-15
15:18
Update the change log and pragma documentation for 3.7.16. check-in: ba9b0b1040 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    41     41       hd_enable_main 1
    42     42     }
    43     43   }
    44     44   
    45     45   chng {2013-03-12 (3.7.16)} {
    46     46   <li>Added the [PRAGMA foreign_key_check] command.
    47     47   <li>Added new extended error codes for all SQLITE_CONSTRAINT errors
           48  +<li>Added SQL functions [unicode(A)] and [char(X1,...,XN)].
    48     49   <li>Improved optimization of queries containing aggregate min() or max().
    49     50   <li>Enhance virtual tables so that they can potentially use an index when
    50     51       the WHERE clause contains the IN operator.
    51     52   <li>Allow indices to be used for sorting even if prior terms of the index
    52     53       are constrained by IN operators in the WHERE clause.
    53     54   <li>Enhance the [PRAGMA table_info] command so that the "pk" column is an
    54     55       increasing integer to show the order of columns in the primary key.

Changes to pages/lang.in.

  2050   2050   funcdef {changes()} {} {
  2051   2051     ^The changes() function returns the number of database rows that were changed
  2052   2052     or inserted or deleted by the most recently completed INSERT, DELETE,
  2053   2053     or UPDATE statement, exclusive of statements in lower-level triggers.
  2054   2054     ^The changes() SQL function is a wrapper around the [sqlite3_changes()]
  2055   2055     C/C++ function and hence follows the same rules for counting changes.
  2056   2056   }
         2057  +
         2058  +funcdef {char(X1,X2,...,XN)} {} {
         2059  +  ^The char(X1,X2,...,XN) function returns a string composed of characters having the
         2060  +   unicode code point values of integers X1 thorugh XN, respectively.
         2061  +}
  2057   2062   
  2058   2063   funcdef {coalesce(X,Y,...)} {} {
  2059   2064     ^The coalesce() function returns a copy of its first non-NULL argument, or
  2060   2065     NULL if all arguments are NULL.  ^Coalesce() must be at least 
  2061   2066     2 arguments.
  2062   2067   }
  2063   2068   
................................................................................
  2313   2318     ^If the Y argument is omitted, trim(X) removes spaces from both ends of X.
  2314   2319   }
  2315   2320   
  2316   2321   funcdef {typeof(X)} {} {
  2317   2322     ^The typeof(X) function returns a string that indicates the [datatype] of
  2318   2323     the expression X: "null", "integer", "real", "text", or "blob".
  2319   2324   }
         2325  +
         2326  +funcdef {unicode(X)} {} {
         2327  +  ^The unicode(X) function returns the numeric unicode code point corresponding to
         2328  +  the first character of the string X.  ^If the argument to unicode(X) is not a string
         2329  +  then the result is undefined.
         2330  +}
  2320   2331   
  2321   2332   funcdef {upper(X)} {} {
  2322   2333     ^The upper(X) function returns a copy of input string X in which all 
  2323   2334     lower-case ASCII characters are converted to their upper-case equivalent.
  2324   2335   }
  2325   2336   
  2326   2337   funcdef {zeroblob(N)} {} {